Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Configurations - Sql Server

Author  Topic 

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2009-01-13 : 09:50:51
I have two ETL servers - one for prod, one for test. Our application environments are dev/qa/test/prod.

If I have the packages stored on the file system in separate folders, is there a nice way of using the SQL Server Configuration table? To put it another way, is there a way I can feed the package via the command line, what the configuration filter is? Or add a 2nd column to the config table to support a Dev/QA/Test column? My source/dest servers are going to be different for each environment.

Anyone have any experience in the trenches on this one?

________________________________________________
I am a man, I can change, if I have to, I guess.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-13 : 10:26:46
http://www.sqlis.com/post/Easy-Package-Configuration.aspx
Go to Top of Page
   

- Advertisement -