What should you do?

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?
A . Convert the package Connection Manager in the first package to a project Connection Manager.
B . Copy the package Connection Manager and paste it into the second package.
C . Convert the project to the Package Deployment model.
D . Set the ProtectionLevel property of the package Connection Manager to DontSaveSensitive to reuse the flat file connection.

View Answer

Answer: A