Data Flow Component Interfaces

The Data Flow Task consists of source and destination adapters that extract and load data between heterogeneous data stores; transformations that modify, summarize, cleanse, and extend data; and the paths that link these components together by connecting output of one component to the input of the other component, thus providing a sequence to the data flow. As mentioned, the Data Flow task can have multiple data sources, transformations, and destinations. These components are designed for high performance with a focus on data movement and manipulation efficiency.

All these components are available in the Toolbox window of the Data Flow tab, and you can drag and drop them onto the Data Flow Designer surface. These ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.