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

• How to: Add a Task or a Container to a Control Flow

To set task properties in the Properties window

• How to: Set Task Properties

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

Help and Information

Getting SQL Server 2005 Assistance