Share via

  • Article

Adding 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 How to: 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 How to: 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 How to: Connect Tasks and Containers by Using a Default Precedence Constraint.

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

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.