Posted by: Colin Smith
So I am working on a project and in this project I am getting more and more exposure to SSIS. This is fun but can be frustrating. I am working on setting up configuration files for connection strings for all the packages. This is pretty simple in BIDS to set up but when I want to move the files to another environment and just edit the file to point to the correct datasources it gets a bit hairy. I think a big part of that is that I do not really know much about XML and that is the type of config doc we are using. I need to learn XML now as well. It never never ends.