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.)
Explanation:
According to https://msdn.microsoft.com/en-us/library/hh230989.aspx
it should be
catalog.create_execution
catalog.add_datatap
catalog.start_execution
agreed