Which stored procedure should you use?

Posted by: Pdfprep Category: 70-463 Tags: , ,

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

Answer: B

Explanation:

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

Leave a Reply

Your email address will not be published.