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:
1. Connect to SSISDB.
2. Query against execution_component_phases and executions.
3. Execute queryhttp://msdn.microsoft.com/en-us/library/hh230981.aspx
http://msdn.microsoft.com/en-us/library/ff878089.aspx
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.
0
0
catalog.executables view includes only metadata of executables
1
0
Correct:
1. Connect to SSISDB.
2. Query against execution_component_phases and executions.
3. Execute query
1
0
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
1
0