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