Microsoft
70-463 · Question #14
70-463 Question #14: Real Exam Question with Answer & Explanation
The correct answer is A: Convert the package Connection Manager in the first package to a project Connection. To share a connection across all packages in an SSIS project, you must promote it from a package-level Connection Manager to a project-level Connection Manager. Only the Project Deployment model supports project-level Connection Managers.
Question
You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project. The first package that you create in this project contains a package connection that accesses a flat file. Additional packages in the project must also access this file. You need to define and reuse the flat file connection in all project packages. What should you do?
Options
- AConvert the package Connection Manager in the first package to a project Connection
- BCopy the package Connection Manager and paste it into the second package.
- CConvert the project to the Package Deployment model.
- DSet the ProtectionLevel property of the package Connection Manager to DontSaveSensitive
Explanation
To share a connection across all packages in an SSIS project, you must promote it from a package-level Connection Manager to a project-level Connection Manager. Only the Project Deployment model supports project-level Connection Managers.
Common mistakes.
- B. Copying and pasting a Connection Manager creates an independent duplicate in the second package; the two copies are not linked and must be maintained separately.
- C. Converting to the Package Deployment model removes project-level features including project Connection Managers, making it impossible to share connections across packages.
- D. The ProtectionLevel property controls how sensitive data such as passwords is stored in the package, and has no effect on whether a connection is scoped to a package or shared across the project.
Concept tested. SSIS project-level Connection Manager promotion and reuse
Community Discussion
No community discussion yet for this question.