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