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:



Leave a Reply 6

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


Koala

Koala

create_execution
add_data_tap
start_execution

Meriem

Meriem

Kaola i think the second step is “add_data_tap_by_guid” because we have the list of packages to analyze.

Lumi

Lumi

I think Koala is right, we have package paths and identification strings, not GUIDs

MKL

MKL

Koala is right

Syed Ahsan

Syed Ahsan

Koala is correct

cao

cao

create_execution
add_data_tap
start_execution