Reputation: 371
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
Upvotes: 0
Views: 6127
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