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
Connect to SSISDB database
catalog.execution_component_phases, catalog.executions
Execute the query
agree