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.
I think the currect answer is C.
me either
C
I found:
Each time a connection manager is used by an SSIS component, a new connection is created. If you set RetainSameConnection to true, you tell the connection manager to create only one connection and hold on to it as long as the package runs. This prevents temporary tables or transactions to be dropped.
So I agree with C
C
Not B – B is for retain same connection if we should use same conensction for differetn tasks (f.e. for one transaction http://microsoft-ssis.blogspot.com/2011/09/ssis-transactions-with-tsql.html)
C.
C
http://www.aiotestking.com/microsoft/you-need-to-define-and-reuse-the-flat-file-connection-in-all-project-packages/
C