Which three actions should you perform in sequence?

You are validating whether a SQL Server IntegrationServices (SSIS) package named Master.dtsx in the SSIS
catalog is executing correctly. You need to displaythe number of rows in each buffer passed between each
data flow component of the package. Which three actions should you perform in sequence? (To answer, move
the appropriate actions from the list of actions tothe answer area and arrange them in the correct order.)

You are validating whether a SQL Server IntegrationServices (SSIS) package named Master.dtsx in the SSIS
catalog is executing correctly. You need to displaythe number of rows in each buffer passed between each
data flow component of the package. Which three actions should you perform in sequence? (To answer, move
the appropriate actions from the list of actions tothe answer area and arrange them in the correct order.)

Answer:

Explanation:

Show Hint

Leave a Reply 1

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

Howie

Howie

1. Run the Master.dtsx package with the logging level set to Verbose.

2. Execute a SQL statement with a package name of Master.dtsx against the catalog.executions view and return its execution ID.

3. Execute SQL statement with the execution ID equal to the previous retrieved execution ID against the catalog.execution_data_statistics view and return the rows_sent column values for all the rows.

Reply