x

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!
more ▼

asked Aug 31 '12 at 01:20 PM in Default

sqlLearner 1 gravatar image

sqlLearner 1
772 28 37 39

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Aug 31 '12 at 08:16 PM

Shawn_Melton gravatar image

Shawn_Melton
5.3k 17 21 29

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x899
x264
x72
x26
x5

asked: Aug 31 '12 at 01:20 PM

Seen: 543 times

Last Updated: Aug 31 '12 at 08:16 PM