Datasheet

Query Parameters window is ordinal (see Figure 1-6). So, the first question mark is represented by

Parameter0, the second by Parameter1, and so on. Map Paramater0 to User::StartDate and

Parameter1 to User::EndDate. Click OK to go back to the Data Flow tab.

Next, drag a Lookup transform onto the design pane. Connect the Product source to the Lookup trans-

form by dragging the green arrow from the source to the transform. Name the Lookup transform Find

Model Name.

Open (by double-clicking) the Lookup transform to configure it. Point the transform to the AdventureWorks

connection manager and to the

[Production].[ProductModel] table by using the appropriate drop-

down list boxes as shown in Figure 1-7. In the Lookup configuration dialog box, select the Columns tab

and you’ll see that there are more arrows connecting the input to the lookup columns than you actually

need. Right-click each arrow and click Delete until the only one remaining is the arrow that connects

ProductModelID on each side, as shown in Figure 1-7. Click Name from the Available Lookup Columns

table and then type the Output Alias of ModelName.

Finally, click the Configure Error Output button. Change the Error column from Fail Component to

Ignore Failure. Click OK twice to exit the transform configuration.

Figure 1-5: Configuring the source

Chapter 1: Getting Started

04_134115 ch01.qxp 4/24/07 6:40 PM Page 10