DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project
deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer
than usual. Which three actions should you perform in sequence? (To answer, move the
appropriate actions from the list ofactions to the answer area and arrange them in the correct order.)

Answer: See the explanation.
Explanation:
Explanation/Reference:
1. Connect to SSISDB.
2. Query against execution_component_phases and executions.
3. Execute queryRef:
http://msdn.microsoft.com/en-us/library/hh230981.aspx
http://msdn.microsoft.com/en-us/library/ff878089.aspx
Connect to SSISDB database
catalog.execution_component_phases, catalog.executions
Execute the query
0
0
agree
0
0