1162
Part IX: Business Intelligence
When the connection is defi ned by a Connection Manager, it can be referenced by other ele-
ments in the package without duplicating the connection defi nition. Connection managers
provide the context for other tasks and components in SSIS. Connection Managers are now
available at both the Project and Package level.Using the UI Enhancements to Easily Confi gure Package Elements
from One Data Flow Task
The following steps can be taken using the AdventureWorks ProductReview example to
quickly confi gure a Data Flow Task, two connection managers, a data fl ow source, and a
data fl ow destination. This example demonstrates the Usability enhancements in SSIS.Adding a Data Flow Task to the Control Flow
To add a Data Flow Task to the package:- Drag a Data Flow Task from the Control Flow toolbox onto the Control Flow tab.
- Move to the Data Flow tab by either double-clicking the Data Flow Task or clicking
the Data Flow tab. - Double-click the Source Assistant, and from the Source Assistant dialog box,
choose Flat fi le under Types; then click OK. The Flat File Connection Manager Editor
appears. - Confi gure your General tab to match that in Figure 52-6, where the Filename is the
fi le location you have saved bikesnsuch.txt. - On the Advanced tab of the editor, click each column and change it, as shown in
Table 52-1 in the DataType and OutputColumnWidth boxes.
TABLE 52-1 How to Confi gure Your Flat File (on the Advanced Tab)Column DataType OutputColumnWidthProdNo Unicode string [DT_WSTR] 50
Name Unicode string [DT_WSTR] 50
Date database timestamp [DT_DBTIMESTAMP] 0
EmailAddress Unicode string [DT_WSTR] 50
Grade Single byte signed integer [DT_I1] 0
Comments Unicode string [DT_WSTR] 3850- Click OK. A new Connection Manager appears in the Connection Managers pane, and
a new Flat File Source appears on the data fl ow.
c52.indd 1162c52.indd 1162 7/31/2012 10:29:26 AM7/31/2012 10:29:26 AM
http://www.it-ebooks.info