PrepAway - Latest Free Exam Questions & Answers

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

PrepAway - Latest Free Exam Questions & Answers

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:

One Comment on “Which three actions should you perform in sequence?


Leave a Reply