DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ADO object source variable that holds a result set that was returned by a
stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object
source variable.
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 Foreach Loop container.
Box 3: Set the enumerator property to Foreach ADO Enumerator and select the variable that contains
the ADO object source.
Note:
Example:
1. Open Control Flow
2. Add and edit ForEach Loop container
3. Set the Enumerator property to ADO Enumerator