Chapter 9. Data Flow Components

In This Chapter

Separating Data Flow from Control Flow

Data Flow Component Interfaces

Considerations when Bringing Data into Data Flow

Data Flow Sources

Data Flow Transformations

Data Flow Destinations

Data Flow Paths

Summary

SQL Server 2005 Integration Services provides several data-oriented services and components. The data flow within a package extracts the data from a data source; performs the transformations, computations, and derivations; and then loads the transformed data to the data destination. The assembly used to represent a data flow is called a data flow pipeline. The data flow engine of Integration Services is a data-driven execution engine that provides a steady flow of data streams onto which atomic ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services 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.

Start your free trial