Add Enumeration to a Control Flow

Integration Services includes the Foreach Loop container, a control flow element that makes it simple to include a looping construct that enumerates files and objects in the control flow of a package. For more information, see Foreach Loop Container.

The Foreach Loop container provides no functionality; it provides only the structure in which you build the repeatable control flow, specify an enumerator type, and configure the enumerator. To provide container functionality, you must include at least one task in the Foreach Loop container. For more information, see Integration Services Tasks.

The Foreach Loop container can include a control flow with multiple tasks and other containers. Adding tasks and containers to a Foreach Loop container is similar to adding them to a package, except you drag the tasks and containers to the Foreach Loop container instead of to the package. If the Foreach Loop container includes more than one task or container, you can connect them using precedence constraints just as you do in a package. For more information, see Precedence Constraints.

To implement a Foreach Loop container in a control flow

1. Add the Foreach Loop container to the package. For more information, see Add or Delete a Task or a Container in a Control Flow
   .

2. Add tasks and containers to the Foreach Loop container. For more information, see Add or Delete a Task or a Container in a Control Flow
   .

3. Connect tasks and containers in the Foreach Loop container using precedence constraints. For more information, see Connect Tasks and Containers by Using a Default Precedence Constraint.

4. Configure the Foreach Loop container. For more information, see Configure a Foreach Loop Container.

See Also

Add or Delete a Task or a Container in a Control Flow
Group or Ungroup Components
Precedence Constraints
Add Iteration to a Control Flow
Control Flow