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 *