Adding Tasks to a Control Flow

When you are working in the control flow designer, the Toolbox in SSIS Designer lists the tasks that Integration Services provides for building control flow in a package. The Toolbox has two nodes, Control Flow Items and Maintenance Plan Tasks. The Maintenance Plan Tasks node lists the tasks that you use to maintain SQL Server databases and jobs. The Control Flow Items node lists the tasks that you use to support data flows in a package, prepare data, perform workflow and business intelligence functions, and implement scripts. The Control Flow Items node also lists the containers—Foreach Loop, For Loop, and Sequence—that you can use to construct a control flow. For more information, see Integration Services Tasks and Integration Services Containers.

A package can include multiple instances of the same task. Each instance of a task is uniquely identified in the package, and you can configure each instance differently.

If you delete a task, the precedence constraints that connect the task to other tasks and containers in the control flow are also deleted.

To add or delete a task

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

To configure a task

• How to: Set the Properties of a Task or Container

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: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Tasks

Grouping Tasks and Containers

Setting Precedence Constraints on Tasks and Containers

Adding Enumeration to a Control Flow

Adding Iteration to a Control Flow

Using Sequence in a Control Flow

Concepts

Designing Package Control Flow