Which three stored procedures should you execute in sequence?

DRAG DROP
A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog.
To troubleshoot some data issues, you must output the data streaming through several data flows into
text files for further analysis. You have the list of data flow package paths and identification strings of
the various task components that must be analyzed.
You need to create these output files with the least amount of administrative and development effort.Which three stored procedures should you execute 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
A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog.
To troubleshoot some data issues, you must output the data streaming through several data flows into
text files for further analysis. You have the list of data flow package paths and identification strings of
the various task components that must be analyzed.
You need to create these output files with the least amount of administrative and development effort.Which three stored procedures should you execute 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:

Ref: http://msdn.microsoft.com/en-gb/library/hh230989(v=sql.110).aspx



Leave a Reply 0

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