Datasheet

Figure 1-4: The Data Flow Task
Drag over an OLE DB Source from the toolbox. Name the source Products. Double-click the source to
configure it, as shown in Figure 1-5. Ensure that you’re pointing to the AdventureWorks connection
manager and then change the Data access mode entry to SQL command. Enter the following command
in the SQL command text window:
SELECT * FROM Production.Product
WHERE SellStartDate > ? and SellStartDate < ?
The query returns all the products that are within a certain date range. The question marks represent
parameter values that will be passed in through a variable. Click the Parameters button to map the ques-
tion marks to the variables you’ve already created. Each question mark parameter you see in the Set
9
Chapter 1: Getting Started
04_134115 ch01.qxp 4/24/07 6:40 PM Page 9