Using Sequence in a Control Flow

Integration Services includes the Sequence container, which makes it simple to divide the control flow in a package into groups of tasks and containers that you can manage as a unit. For more information, see Sequence Container.

Using Sequence containers lets you handle the control flow in a package in more detail, without having to manage individual tasks and containers. For example, you can set the Disable property of the Sequence container to True to disable all the tasks and containers in the Sequence container.

If a package has many tasks, it can be helpful to group the tasks in Sequence containers, because you can collapse and expand Sequence containers. You can also create task groups, which expand and collapse using the Group box. However, the Group box is a design-time feature that has no properties or run-time behavior. For more information, see Grouping Tasks and Containers.

The Sequence container can include multiple tasks in addition to other containers. Adding tasks and containers to a Sequence container is similar to adding them to a package, except you drag the tasks and containers to the Sequence container instead of to the package container. If the Sequence container includes more than one task or container, you can connect them using precedence constraints just as you do in a package. For more information, see Precedence Constraints.

You set the properties of the Sequence container in the Properties window that Business Intelligence Development Studio includes.

To implement a Sequence container in a control flow

  1. Add the Sequence container to the package. For more information, see How to: Add or Delete a Task or a Container in a Control Flow.

  2. Add tasks and containers to the Sequence container. For more information, see How to: Add or Delete a Task or a Container in a Control Flow.

  3. Connect tasks and containers in the Sequence container using precedence constraints. For more information, see How to: Connect Tasks and Containers by Using a Default Precedence Constraint.

  4. Configure the Sequence container. For more information, see How to: Set the Properties of a Task or Container.

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.