Understanding Data Flow Transformations
The Data Flow work area is where you will perform the bulk of your ETL activities. Here, you will read data sources, manipulate data by using transformations, and write your transformed data to a destination. An SSIS package can contain multiple data flows. This feature allows you to segregate your ETL tasks, for example, by business or subject area. Double-clicking a Data Flow task in the Control Flow area will take you to the Data Flow window for that particular task (shown previously in Figure 8–14).
Data Sources
To begin work in the Data Flow area, you will select at least one data flow source component. Usually, you will select at least one data flow transformation and at least one data flow destination. ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
