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 of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Explanation:
1. Connect to SSISDB.
2. Query against execution_component_phases and executions.
3. Execute query
Ref:
http://msdn.microsoft.com/en-us/library/hh230981.aspx
http://msdn.microsoft.com/en-us/library/ff878089.aspx