You need to define and reuse the connection managers in all the packages by using the least development effort

You are designing a complex SQL Server Integration Services (SSIS) project that uses the
Project Deployment model.
The project will contain between 15 and 20 packages. All the packages must connect to the
same data source and destination.
You need to define and reuse the connection managers in all the packages by using the
least development effort.
What should you do?

You are designing a complex SQL Server Integration Services (SSIS) project that uses the
Project Deployment model.
The project will contain between 15 and 20 packages. All the packages must connect to the
same data source and destination.
You need to define and reuse the connection managers in all the packages by using the
least development effort.
What should you do?

A.
Copy and paste the connection manager details into each package.

B.
Implement project connection managers.

C.
Implement package connection managers.

D.
Implement parent package variables in all packages.



Leave a Reply 0

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