Question about configurations

I've been reading up on package configurations, but I'm not quite sure how to use them correctly. If I am developing a package, I want to connect to a testing server. Then, when it is working correctly, I want to connect to a production server. Are configurations a helpful way of doing this, or would it only be helpful if in the future, I need to make the packages reference a different server?

Hi Micheal,

That is exactly the use I want to make of configurations. I have been experimenting with registry and configuration file but neither seem to work. frankly I don't get it because I do exactly what I find in literature concerning this topic;

Keep me posted if you find the solution I'll do the same.

Greetings,

Paul.

|||

Configurations are all about taking the environment specific values out of a package and storing them elsewhere to make your packages portable. The configuration will then provide this information when you load the package.

Easy Package Configuration
(http://www.sqlis.com/default.aspx?26)

Jamie Thomson - SSIS Jibber Jabber : SSIS: Indirect configurations ROCK!
(http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2342.aspx)

Keep Your Packages in the Dark
(http://www.sqlmag.com/Article/ArticleID/47688/sql_server_47688.html)

|||

Hi Michael,

You might find the solution in my thread Package Configuration using xml-file fails from yesterday. Jamie Thomson gave a very usefull answer.

Greetings,

Paul