Adding a Data Flow Task
SQL Server 2005 Integration Services (SSIS) packages that extract, transform, and load data must include at least one Data Flow task. The Data Flow task encapsulates the Integration Services data-flow engine that moves data from source to destination, and calls the transformations that modify the data as it moves from source to destination. For more information, see Data Flow Task.
Adding a Data Flow task to the control flow of a package is the first step in implementing a data flow in a package. A package can include multiple Data Flow tasks, each with its own data flow. After the control flow includes a Data Flow task, you can begin to build the data flow that a package uses.
To add a Data Flow task to a package
To set task properties in the Properties window
See Also
Tasks
Extracting Data
Transforming Data
Loading Data
Connecting Components
Handling Errors in Data
Concepts
Data Flow Task
Creating Package Data Flow
Other Resources
Lesson 1: Creating the Project and Basic Package