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:
