SSIS - Container

About

In SSIS control flow, containers:

• group related tasks together
• or define iterative processes.

As you can nest containers within other containers, it permits to create a hierarchy of task.

Containers can be start or endpoints for precedence constraints.

Articles Related

Type

SSIS packages can contain the following kinds of container:

Task

Each control flow task has its own implicit container.

Sequence

Sequence containers group tasks and other containers.

It enables to:

• set properties at the container level that apply to all elements within the container.
• Disable a logical subset of the package for debugging purposes.
• Create a scope for variables.
• Manage transactions at a granular level.

For Loop

For Loop containers performs a loop until a condition is met.

The defined variable can be used with the following syntax:

@[User::counter]

Foreach Loop

Foreach Loop containers performs a loop with an collection.

• File - Files in a folder.
• Item – A property collection for an SSIS object.
• ADO. A Recordset.
• ADO.NET Schema Rowset. Tables in a dataset or rows in a table.
• Variable – Array.
• Nodelist - Elements and attributes in an XML document.
• SMO – A collection of SQL Server Management Objects.