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 . catalog.create_environment_variable
B . catalog.create_environment_reference
C . catalog.set_execution_parameter_value
D . catalog.set_environment_variable_value

View Answer

Answer: B

Explanation:

Environments (Test, Production etc) are associated with projects by creating references to the environments in the projects.