Hi, I have created a package in SSIS.
I want to now run the package on different DB's in Management Studio but need to find a way to pass in the the OLD DB SOurce as a paraemter instead of a hardcoded DB, this way I do not need to create a package for each DB that I want to execute the package on.
Is this possible? If so can someone give me some infomration on how to accomplish this.Thanks!
asked Aug 31 '12 at 01:20 PM in Default
You will want to look at package configurations.
You will setup your connection manager source to the database and server using variables for your initial catalog and server/instance. Then in your package configuration the value of that variable is set.
A good walkthrough can be found here.
answered Aug 31 '12 at 08:16 PM