user3494471
user3494471

Reputation: 371

How to create SSIS Dynamic Connection

I am having 10 different ssis packages.Each and every packages having source and destination connection. For example taking the data from source and moving to destination .Each and every packages I have created source and destination connection in connection manager.How to create source and destination dynamically instead of creating source and destination each and every packages. Example shown in the picture below enter image description here

Upvotes: 0

Views: 6127

Answers (1)

Govind
Govind

Reputation: 979

Move the connection strings to configuration file. So that you can change whenever you want without editing package. To create configuration, in Control flow right click and choose configurations

Or

Goto SSIS menu->Package configurations. Navigate to next step and choose required connections and dynamic variables to config file.

Refer below link

http://www.sqlshack.com/using-xml-file-configure-ssis-package/

Upvotes: 1

Related Questions