70-463 · Question #236
You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to the same data source a
The correct answer is C. Implement project connection managers.. Project connection managers in the SSIS Project Deployment Model are defined once at the project level and shared automatically across all packages, minimizing duplicate configuration effort.
Question
You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to the same data source and destination. You need to define and reuse the connection managers in all the packages by using the least development effort. What should you do?
Options
- AImplement parent package variables.
- BCopy and paste connection managers from one package to the others.
- CImplement project connection managers.
- DImplement package connection managers.
How the community answered
(36 responses)- A8% (3)
- B6% (2)
- C83% (30)
- D3% (1)
Why each option
Project connection managers in the SSIS Project Deployment Model are defined once at the project level and shared automatically across all packages, minimizing duplicate configuration effort.
Parent package variables require a parent-child package execution pattern where a parent package passes values to child packages via Execute Package tasks, which adds architectural complexity rather than reducing effort.
Copying and pasting connection managers into each of the 10 packages creates 10 separate copies that must each be maintained individually, which is the opposite of minimizing development effort.
Project connection managers are a feature of the Project Deployment Model that allows a single connection manager to be defined at the project level and reused by all packages within that project, eliminating the need to configure the same connection in each of the 10 packages individually.
Package connection managers are scoped to a single package and must be created and configured separately in each package, requiring the same work to be repeated 10 times.
Concept tested: SSIS Project Deployment Model project-level connection managers
Source: https://learn.microsoft.com/en-us/sql/integration-services/connection-manager/integration-services-ssis-connections
Topics
Community Discussion
No community discussion yet for this question.