Which three actions should you perform in sequence?

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.)

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:

Explanation:



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Howie

Howie

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

Howie

Howie

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.

Moshe David

Moshe David

correct
catalog.executables view includes only metadata of executables

Google

Google

Sites of interest we’ve a link to.