Sequence Container

The Sequence container defines a control flow that is a subset of the package control flow. Sequence containers group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow.

There are many benefits of using a Sequence container:

• Disabling groups of tasks to focus package debugging on one subset of the package control flow.

• Managing properties on multiple tasks in one location by setting properties on a Sequence container instead of on the individual tasks.

• Providing scope for variables that a group of related tasks and containers use.

You can set a transaction attribute on the Sequence container to define a transaction for a subset of the package control flow. In this way, you can manage transactions at a more granular level. For example, if a Sequence container includes two related tasks, one task that deletes data in a table and another task that inserts data into a table, you can configure a transaction to ensure that the delete action is rolled back if the insert action fails. For more information, see Incorporating Transactions in Packages.