February 20, 2014 at 7:19 am
Hello
Can anyone advice me how to use different config xml files for different solution configuration.
For instance: I have two dtsConfig files : Test.xml and Prod.xml
Furthermore do I have to different solution configurations : Test and Prod.
So when I want to build and deploy to Test I wish the Test.xml to be used. And vice versa for Prod.
Basically similar to the way one would configue web.config files ind VS for .Net.
I can easily add both config xmls or just one xml, to the package configuration. But when I build I get
February 20, 2014 at 11:31 am
You can use Environmental variable. The environmental variable will point to the Test.xml when you are into Test environment. When you are into production, your environment variable will point to Prod.xml
You can get a reference here:
http://www.jasonstrate.com/2011/01/31-days-of-ssis-environmental-variable1731/
Vikash Kumar Singh || www.singhvikash.in
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply