1176
Part IX: Business Intelligence
Using the Data Flow to Move Your Data
Unlike other tasks that you can confi gure in the control fl ow, a Data Flow task does not
show an Editor dialog in response to an edit request. Instead, it switches to the Data Flow
tab to view/confi gure the task details. Each component appearing on the design surface can
in turn be confi gured in the Properties pane, by a component-specifi c editor dialog, and, for
many components, by an advanced editor as well.Each data fl ow must begin with at least one Data Flow source, and generally ends with one
or more Data Flow destinations, providing a source and sink for the data processed within
the task. Between source and destination, any number of transformations may be confi g-
ured to sort, convert, aggregate, or otherwise change the data.Out of each source or transformation, a green Data Flow path arrow is available to connect
to the next component. Place the next component on the design surface, and connect it to
the path before attempting to confi gure the new component, as the path provides neces-
sary meta-data for confi guration. Follow a similar process for the red error fl ow for any
component that has been confi gured to redirect error rows. Figure 52-10 shows the Data
Flow created earlier.FIGURE 52-10
The Data Flow from Product.ProductReview.Use the Data Flow Path Editor to view/confi gure paths as necessary, double-clicking a path
to invoke its editor. The editor has three pages:c52.indd 1176c52.indd 1176 7/31/2012 10:29:29 AM7/31/2012 10:29:29 AM
http://www.it-ebooks.info