Config

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arne Garvander - 28 Jul 2008 19:41 GMT

How do I add a config file to a SSIS Package?
How do I change source and destination server when I move a package from a
development environment to a destination environment?

Signature

Arne Garvander
(I program VB.Net for fun and C# to get paid.)

Reply to this Message

Denny Cherry - 28 Jul 2008 22:06 GMT

I assume that you run the package from a job? There is a tab on the
job step properties which says which config file to use.

If you are running it some other way add the /ConfigFile (or /CONF)
switch and give it the path to the config file.

Denny

>How do I add a config file to a SSIS Package?
>How do I change source and destination server when I move a package from a
>development environment to a destination environment?

Reply to this Message

Todd C - 29 Jul 2008 17:33 GMT

Arne:

I wrote a blog concerning SSIS Configurations that you may find helpful:

http://toddchitt.wordpress.com/2008/06/27/ssis_config/

Signature

Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

> How do I add a config file to a SSIS Package?
> How do I change source and destination server when I move a package from a
> development environment to a destination environment?

Reply to this Message

Joe H - 31 Jul 2008 16:12 GMT

I can vouch for this guy's approach. I may have close to 20 packages that
pull from many data sources with a Master_Run all package. Using this guys
way takes seconds to bounce between running it on local dev to agency dev or
QA or PROD - it's the bomb!

> Arne:
>
[quoted text clipped - 6 lines]
>> a
>> development environment to a destination environment?

Reply to this Message