O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required