DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains several tasks that must repeat until an expression evaluates to
FALSE.
You need to add and configure a container to enable this design.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order,)
Answer: See the explanation.
Explanation:
Box 1: Open the Control Flow designer of the package.
Box 2: Add and edit a For Loop container.
Box 3: Configure the EvalExpression property.Note:
* You create the control flow in a package by using the control flow designer.
Integration Services includes three types of containers that you can use in a control flow.
/ Foreach Loop container
/ For Loop container
/ Sequence container
* For Loop Container
The For Loop container defines a repeating control flow in a package. The loop
implementation is similar to the For looping structure in programming languages. In each
repeat of the loop, the For Loop container evaluates an expression and repeats its workflow
until the expression evaluates to False.
The For Loop container uses the following elements to define the loop:
/ An optional initialization expression that assigns values to the loop counters.
/ An evaluation expression that contains the expression used to test whether the loop should
stop or continue.
/ An optional iteration expression that increments or decrements the loop counter.