Export (0) Print
Expand All

Adding Enumeration to a Control Flow

SQL Server 2005 Integration Services (SSIS) 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.

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

  2. Add tasks and containers to the Foreach Loop container. For more information, see How to: Add a Task or a Container to 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 Using a Default Precedence Constraint.

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

Community Additions

ADD
Show:
© 2015 Microsoft