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.