To customize the data flow task in the package you're
building, follow these steps:
- Select the Data Flow tab in the Package Designer. The single Data Flow Task in the package will automatically be selected in the combo box.
- Drag an OLE DB Source from the Toolbox and drop it on the Package Designer.
- Drag a Character Map Transformation from the Toolbox and drop it on the Package Designer.
- Drag a Flat File Destination from the Toolbox and drop it on the Package Designer.
- Click on the OLE DB Source on the Package Designer to select it.
- Drag the green arrow from the bottom of the OLE DB Source and drop it on top of the Character Map Transformation.
- Click on the Character Map Transformation on the Package Designer to select it.
- Drag the green arrow from the bottom of the Character Map Transformation and drop it on top of the Flat File Destination.
- Double-click the OLE DB Source to open the OLE DB Source Editor. Notice that it uses the Chapter16 OLE DB connection manager by default.
- Select the HumanResources.Department table. Figure 16-7 shows the completed OLE DB Source Editor.
- Click OK.
- Double-click the Character Map Transformation.
- Check the Name column.
- Select In-Place Change in the Destination column.
- Select the Uppercase operation. Figure 16-8 shows the completed Character Map Transformation Editor.
Setting up Character Map
Transformation
- Click OK.
- Double-click the Flat File Destination.
- Select the DepartmentList Flat File Connection Manager.
- Select the Mappings page of the dialog box.
- Drag the Name column from the Available Input Columns list and drop it on top of the DepartmentName column in the Available Destination Columns list. Figure 16-9 shows the completed Mappings page.
Configuring flat file
destination
- Click Ok
Adding data flows
The data flows in this package take a
table from the Chapter16 database, transform one of the columns in that table
to all uppercase characters, and then write that transformed column out to a
flat file.
No comments:
Post a Comment