Configure a For Loop Container

 

Applies To: SQL Server 2016

This procedure describes how to configure a For Loop container by using the For Loop Editor dialog box.

For an example of the For Loop container, see SSIS Loops that do not fail on bimonkey.com.

To configure the For Loop container

  1. In SQL Server Data Tools (SSDT), double-click the For Loop container to open the For Loop Editor.

  2. Optionally, modify the name and description of the For Loop container.

  3. Optionally, type an initialization expression in the InitExpression text box.

  4. Type an evaluation expression in the EvalExpression text box.

    System_CAPS_ICON_note.jpg Note


    The expression must evaluate to a Boolean. When the expression evaluates to false, the loop stops running.

  5. Optionally, type an assignment expression in the AssignExpression text box.

  6. Optionally, click Expressions and, on the Expressions page, create property expressions for the properties of the For Loop container. For more information, see Add or Change a Property Expression.

  7. Click OK to close the For Loop Editor.

For Loop Container
Integration Services (SSIS) Expressions
Use Property Expressions in Packages

Community Additions

ADD
Show: