In SSIS control flow, containers:
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.
SSIS packages can contain the following kinds of container:
Each control flow task has its own implicit container.
Sequence containers group tasks and other containers.
It enables to:
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 containers performs a loop with an collection.