Which three stored procedures should you execute in sequence?

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 furtheranalysis.
You have the list of data flow package paths and identification strings of the various task componentsthat 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 areaand arrange them in the correct order.)

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 furtheranalysis.
You have the list of data flow package paths and identification strings of the various task componentsthat 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 areaand arrange them in the correct order.)

Answer:

Explanation:

Show Hint

Leave a Reply 1

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

Howie

Howie

1. Catalog.create_execution

2. Catalog.add_data_tap

3. Catalog.start_execution

Reply