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 display the 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 to the 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 display the 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 to the answer area and arrange them in the correct order.)

Answer:

Explanation:

Show Hint

Leave a Reply 4

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

MicrosoftAnswer

MicrosoftAnswer

Run the Master.dtsx package with the logging Level set to Verbose.

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

Execute a SQL Statement with the exectuion ID equal to the previously retrieved execution ID against the catalog.execution_data_statistics view and return the rows_sent column values for all the rows.

Reply

Mahmoud Ibrahim

Mahmoud Ibrahim

4-1-3 Correct

Reply