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: Correct
Explanation:
1. Add Sequence Container
2. Add SQL tasks to Sequence container
3. Add mail task with precedence to Sequence container
#3: Add a Send Mail task to the Control Flow, and a precedence constraint of COMPLETION to the Sequence container
0
0
Why do you need sequence container? You have to implement parallel process. The sequence container will execute tasks one after another. I think 5-4-1 is the correct answer
0
0
Ups, my mistake. You are right.
0
0
2
6
1
0
0