Adding a Data Flow Task

Integration Services 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

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.