Which three actions should you perform in sequence?

DRAG DROP
You are validating whether a SQL Server Integration Services (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.)

DRAG DROP
You are validating whether a SQL Server Integration Services (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: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* You are going to become very very familiar indeed with [catalog].[executions]. It is a view
that provides a record of all package executions on the server and, most importantly, it
contains [execution_id] – the identifier for each execution and the field to which all other
objects herein will be related.



Leave a Reply 1

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


Miguel

Miguel

I think that on box 3 is:

Box 3: …execution_component_phases…catalog.executions view