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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-09-05 : 05:10:50
|
| Hi,I would like to put the ssis package from Dev to Prod environment.How should the config file be configured so that I do not have to change anything while going from Dev to Prod?At present in Dev, I have a path in the config file which looks at the database in Dev.I can change this to point to live when moving to production but is there an easier way so that I do not have to make any changes when going from Dev to Prod please?Thanks |
|
|
favaz.farook@gmail.com
Starting Member
8 Posts |
Posted - 2008-09-12 : 10:27:39
|
| The *.dtsconfig file is a best way of having values which need to be configured like File Path, Db Names etc. so i think you have used the correct method, its obvious that if you need the value changed then you have to change it at the file or you could use a Tables to hold the values and get the values from the tables then still you need to change the table values when you want to change it |
 |
|
|
|
|
|
config file