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:
catalog.create_execution
catalog.add_data_tap
catalog.start_execution
1)Catalog.create_execution
2)Catalog.add_data_tap
3)Catalog.start_execution
https://msdn.microsoft.com/pt-br/library/hh230989(v=sql.120).aspx
create_execution
add_data_tap
start_execution