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.

The correct answer is B. catalog.create_environment_reference. To associate (link) an Environment with a project in the SSIS catalog, you use catalog.create_environment_reference. This stored procedure creates a reference from a project to an environment, allowing the project's parameters to be mapped to environment variables. The other proc

Configure and deploy SSIS solutions

Question

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?

Options

Acatalog.create_environment_variable
Bcatalog.create_environment_reference
Ccatalog.set_execution_parameter_value
Dcatalog.set_environment_variable_value

How the community answered

(65 responses)

A
3% (2)
B
88% (57)
C
8% (5)
D
2% (1)

Explanation

To associate (link) an Environment with a project in the SSIS catalog, you use catalog.create_environment_reference. This stored procedure creates a reference from a project to an environment, allowing the project's parameters to be mapped to environment variables. The other procedures serve different purposes: catalog.create_environment_variable adds a variable inside an existing environment; catalog.set_execution_parameter_value sets a parameter value at execution time; and catalog.set_environment_variable_value changes the value stored in an environment variable. None of those establish the project-to-environment linkage that the question requires.

Topics

#SSIS catalog#environment reference#catalog stored procedure#project deployment

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice