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:
Explanation:
Correct
1. Add Sequence Container
2. Add SQL tasks to Sequence container
3. Add mail task with precedence to Sequence container
Correct:
1. Connect to SSISDB.
2. Query against execution_component_phases and EXECUTABLES.
3. Execute query
The question asks for CONTROL FLOW TASKS.
catalog.executables -> This view displays a row for each executable in the specified execution. An executable is a task or container that you add to the control flow of a package.
catalog.executions -> Displays the instances of package execution in the Integration Services catalog
catalog.execution_component_phases -> Displays the time spent by a data flow component in each execution phase.
5-3-1
catalog.executables view includes only metadata of executables
Correct:
1. Connect to SSISDB.
2. Query against execution_component_phases and executions.
3. Execute query
1. Add Sequence Container
2. Add SQL tasks to Sequence container
3. Add mail task with precedence to Sequence container
I agree with ShirazBoy. U need to know which components are taking a long time.
execution_component_phases tells you the components + duration, Executions tells which execution they belong to.
1. Connect to SSISDB.
2. Query against execution_component_phases and executIONS.
3. Execute query