I'm working on a SSIS package which I want to deploy onto our development environment on a daily basis as I work on it. In addition, I want it to be easy to deploy to production. We're using xml configuration files for our packages, but I haven't seen anyone discuss the entire development process.
Do people keep their production and development configuration files in source control? If so, how? Are they part of your BIDS SSIS project? I tried adding them to "Miscellaneous". i.e. Example:
I haveÃÂ a project with the following SSIS Packages in it:
In the Miscellaneous folder I have:
I did this so I can keep them in source control. We don't use package deployment utilities, we just deploy by hand, but putting the files in Miscellaneous breaks the building of the deployment utilities because it attempts to copy the config files into the Deployment directory twice.
In addition, I set up the package configurations such that the
View Complete Post