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
The answer should be execution_component_phases and EXECUTABLES
catalog.executables – execution per task
catalog.executions – execution per package
catalog.execution_component_phases – execution per component
0
2
executable doesn’t have time.. thus should be execution
https://msdn.microsoft.com/en-us/library/hh479595.aspx
3
0
The answer should be execution_component_phases and EXECUTABLES
0
3