O'Reilly logo

Professional SQL Server™ 2005 Integration Services by Mike Murphy, Haidong Ji, Jason Gerard, Erik Veerman, Andy Leonard, Kathi Kellenberger, Douglas Hinson, Darren Green, Allan Mitchell, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4.1. Containers

Containers are objects that help SSIS provide structure to one or more tasks. They can help you loop through a set of tasks until a criterion has been met or can help you group a set of tasks logically. Containers can also be nested, containing other containers. Containers are set in the Control Flow tab in the Package Designer. There are four types of containers in the Control Flow tab: Task Host, Sequence, For Loop, and Foreach containers.

4.1.1. Task Host Containers

The task host container is the default container that single tasks fall into. You'll notice that this type of container is not in the Toolbox in Visual Studio. In fact, even if you don't specify a container for a task, it will be placed in a task host container. The SSIS architecture extends variables and event handlers to the task through the task host container.

4.1.2. Sequence Containers

Sequence containers handle the flow of a subset of a package and can help you divide a package into smaller, more-manageable pieces. Some nice applications that you can use sequence containers for include the following:

  • Grouping tasks so that you can disable a part of the package that's no longer needed

  • Narrowing the scope of the variable to a container

  • Managing the properties of multiple tasks in one step by setting the properties of the container

  • Using one method to ensure that multiple tasks have to execute successfully before the next task executes

Sequence containers show up like any other task in your Control ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required