You need to define and reuse the flat file connection in all project packages

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?

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 theflat
file connection.

Explanation:
checked



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Howie

Howie

A.
Convert the package Connection Manager in the first package to a project Connection Manager.