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.


more ▼

asked Aug 31, 2012 at 01:20 PM in Default

avatar image

sqlLearner 1
972 43 51 57

(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, 2012 at 08:16 PM

avatar image

6.6k 21 26 34

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Aug 31, 2012 at 01:20 PM

Seen: 830 times

Last Updated: Aug 31, 2012 at 08:16 PM

Copyright 2018 Redgate Software. Privacy Policy