question

sqlLearner 1 avatar image
sqlLearner 1 asked

SSIS Package Source Parameters

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!
ssistsqlparameterspackagemanagement-studio
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered
You will want to look at [package configurations][1]. 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][2]. [1]: http://msdn.microsoft.com/en-us/library/ms141682.aspx [2]: http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.