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 Microsoft Excel file. Additional packages in the project must also access this file.
You need to define and reuse the Excel file connection in all project packages.
What should you do?
A.
Copy the package Connection Manager and paste it in the second package.
B.
Set the RetainSameConnection property of the package Connection Manager to True.
C.
Convert the package Connection Manager in the first package to a project Connection
Manager.
D.
Convert the project to the Package Deployment model.
Package connections cannot be shared between packages. Right answer has to be C
Agree, “C” is correct.
Absolutely C.
PS: I’m surprised this ‘admin’ missed a lot of easy questions. Ain’t sure he had SSDT, Master Data Manager, SSMS, Data Quality Services, and Master Data Server installed in a demo environment. He could have easily tested out some of the answer choices, and (perhaps), not select wrongly.
option B is completely wrong in this scenario as they want the connections to be used by other packages, but option b works if you want to keep a connection open until your package execution does not complete. This helps in temp table uses. So correct answer is C