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:
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.
0
0
4-1-3
0
0
4-1-3 Correct
0
0
4-1-3
0
0