70-463 · Question #17
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 C. catalog.create_environment_reference. Linking an existing SSIS catalog Environment to a project requires creating an environment reference that associates the project with that Environment. The catalog.create_environment_reference stored procedure performs this association.
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.set_environment_reference_type
- Bcatalog.set_environment_property
- Ccatalog.create_environment_reference
- Dcatalog.create_environment
How the community answered
(40 responses)- A5% (2)
- C93% (37)
- D3% (1)
Why each option
Linking an existing SSIS catalog Environment to a project requires creating an environment reference that associates the project with that Environment. The catalog.create_environment_reference stored procedure performs this association.
catalog.set_environment_reference_type modifies the type (relative or absolute) of an environment reference that already exists; it cannot create a new reference.
catalog.set_environment_property sets a property such as the description of an Environment object itself, and does not associate an Environment with a project.
catalog.create_environment_reference creates a reference between a deployed SSIS project and an Environment in the SSISDB catalog, which is the required step to make the Environment's variables available for mapping to project or package parameters.
catalog.create_environment creates a brand-new Environment folder object in the catalog; since the Environment already exists, this procedure is not needed and would not link it to the project.
Concept tested: SSIS catalog environment reference creation for project association
Source: https://learn.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-create-environment-reference-ssisdb-database
Topics
Community Discussion
No community discussion yet for this question.