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:
1. Run with verbose settings
2. Get Execution ID from .executions
3. Get stats from .execution_data_statistics ( rows_sent )
Ref: http://msdn.microsoft.com/en-us/library/hh230986.aspx



Leave a Reply 1

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


Maya

Maya

This is for 70.467