70-467 · Question #85
You need to configure a parameter for the database connection string. What should you do?
The correct answer is B. Use a required project parameter. In SSIS, project parameters are the correct scope for shared settings like connection strings that apply across multiple packages in a project.
Question
You need to configure a parameter for the database connection string. What should you do?
Options
- AUse a required package parameter.
- BUse a required project parameter.
- CUse a package configuration.
- DUse a global variable.
How the community answered
(49 responses)- A16% (8)
- B71% (35)
- C8% (4)
- D4% (2)
Why each option
In SSIS, project parameters are the correct scope for shared settings like connection strings that apply across multiple packages in a project.
A required package parameter is scoped only to a single package, so it cannot be centrally managed across all packages that need the same connection string.
A required project parameter is defined at the SSIS project level and is available to all packages within that project, making it the appropriate scope for a database connection string shared across packages. Marking it as required forces the value to be supplied at deployment or runtime, preventing misconfiguration. This approach supports the SSIS project deployment model introduced in SQL Server 2012.
Package configuration is a legacy mechanism from the older SSIS package deployment model and is superseded by the project deployment model's parameter system.
Global variables are not a supported construct in SSIS for passing configuration values; parameters and connection managers are the correct mechanisms.
Concept tested: SSIS project vs package parameter scoping
Source: https://learn.microsoft.com/en-us/sql/integration-services/integration-services-ssis-package-and-project-parameters
Topics
Community Discussion
No community discussion yet for this question.