Which three actions should you perform in sequence?

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,)

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:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


CorvusAlpha

CorvusAlpha

1. Open Control Flow
2. Add and edit ForEach Loop container
3. Set the Enumerator property to ADO Enumerator