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

You are designing a SQL Server Integration Services (SSIS) project that uses the Project
Deployment Model.
The project will contain 10 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 SQL Server Integration Services (SSIS) project that uses the Project
Deployment Model.
The project will contain 10 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.
Implement parent package variables.

B.
Copy and paste connection managers from one package to the others.

C.
Implement project connection managers.

D.
Implement package connection managers.



Leave a Reply 0

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