Hi,
I am wanting to create my first SSIS deployment project. As a part of this project I will be deploying the .dtsx folder the correct directory. It will also copy the .dtsconfig file to the same directory.
However I need to correctly substitute the values within the dtsconfig file appropriately for each environment.
There will be variables that we centrally control within the variables section such as SERVERNAME, SMTPHOSTNAME, SHAREFOLDERPATH, etc
However there will be ones that will be set by the developers such as EMAILTO, EMAILFROM, EMAILSUBJECT, etc which we will be wanting them to define somewhere a values for each variable for each environment.
Therefore I have been looking for a way to be able to include a file in the Octopus package that will contain variables and the value relating to each environment. Octopus can then read that in to the deployment and then substitute the dtsconfig files for each different environment.
E.g the EMAILTO value in dtsconfig deployed to the DEV environment would have developersname@domain.com
EMAILTO for the TESTING Environment would have testers@domain.com
EMAILTO for PROD would have the real email address
I was hoping that I could has an XML or REST file which would then create Octopus variables and the individual values for each environment which I could then use in the substitution at the time of deployment specific to the individual environment being deployed to.
Thoughts?