DRAG DROP
You are designing a SQL Server Integration Services (SSIS) package to execute 12
Transact-SQL (T-SQL) statements on a SQL Azure database.
The T-SQL statements may be executed in any order. The T-SQL statements have
unpredictable execution times.
You have the following requirements:
The package must maximize parallel processing of the T-SQL statements.
After all the T-SQL statements have completed, a Send Mail task must notify administrators.
You need to design the SSIS package.
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: Add a Sequence container to the control flow.
Box 2: Add 12 Execute SQL tasks to the Sequence container and configure the tasks.Box 3: Add a Send mail task to the control flow. Add a precedence constraint for Completion
to the to the Sequence container and link it to the Send Mail task.Note:
The Sequence container defines a control flow that is a subset of the package control flow.
Sequence containers group the package into multiple separate control flows, each
containing one or more tasks and containers that run within the overall package control flow.Sequence Container