1165
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
- Double-click the Derived Column transform to open its editor.
- Enter Modifi edDate in the Derived Column Name fi eld.
- In the Derived Column box, click the drop-down arrow, and select <add as a new
column>. - Enter GetDate() in the Expression Box.
- Click OK.
To confi gure the Lookup used to determine ProductID, follow these steps: - Drag a Lookup transform from the data fl ow toolbox onto the Data Flow tab under
the Derived Column transform. - Click the Derived Column transform.
- Drag the green data fl ow path from the Derived Column transform to the Lookup
transform. - Double-click the Lookup transform to open its editor.
- Click Connection in the editor.
- Click the Use Results of a SQL Query button.
- Click inside the Query Editor.
- Type: Select ProductID, ProductNumber from Production.Product.
- Click Columns.
- Click and hold ProdNo from Available Input Columns.
- Drag to ProductNumber from Available Lookup Columns so that a line connects the
two. - Click the check box next to ProductID from available Lookup Columns.
- Click OK.
You now added the ModifedDate and the ProductID columns to the Data Flow in this Data
Flow Task. You are ready to map all the columns to the destination and run the package in
debug mode.
To fi nish and map, follow these steps:- Click the Lookup transform.
- Drag the green data fl ow path from the Lookup transform to the OLE Destination.
- The Input Output Selection dialog box appears. Click inside the output box, and
select Lookup Match Output from the drop-down menu. - Double-click the OLE DB Destination to bring up its editor.
- If not already chosen, choose your AdventureWorks Connection Manager for the OLE
DB Connection Manager.
c52.indd 1165c52.indd 1165 7/31/2012 10:29:27 AM7/31/2012 10:29:27 AM
http://www.it-ebooks.info