Microsoft Exam Questions

Which stored procedure should you use?

You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An
Environment has been defined in the SSIS catalog. You need to add the Environment to the project. Which
stored procedure should you use?

A.
The catalog.create_execution stored procedure.

B.
The catalog.create_environment_variable stored procedure.

C.
The catalog.create_environment_reference stored procedure.

D.
The catalog.add_data_tap stored procedure.