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 determinewhether 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:
1. Connect to the SSISDB database
2. Write query against the catalog.execution_component_phase view. Add a calculation to the query to compare durations to the catalog.executions view.
3. Execute the query
1. Create an OnError event handler for the Data Flow task.
2. Add a Script task
3. In the ReadOnlyVariables list, select system::ErrorDescription and add conditional logic to invoke the FireError method.
correct
catalog.executables view includes only metadata of executables
Sites of interest we’ve a link to.