|
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!
(comments are locked)
|
|
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.
(comments are locked)
|
Your answer
