SSIS R2 Configuration File Issue Fixed

, 2010-05-14

Using configurations files in SSIS is a great way to change how your package will run from outside the development environment.  One thing that I’ve always recommended when using files (I actually prefer to use config tables) is to have one file for each of the connection managers in the package. 

The reason I have always recommended this instead of one file for all your packages is because previously in SSIS 2005 and 2008 if you used one file for all your packages then you must include all the connection manager from the file in all your packages for it to actually run.  So if you decided it was easier to maintain one file for all your connections SSIS would force you to use every connection in all packages regardless of whether or not the package actually used it.  If you did not include all the connection that are in the file then SSIS will throw an error telling you that you are missing the connection.

In SQL Server 2008 R2 this problem is actually fixed.   I didn’t realize there were any design changes with SSIS in R2 but this is actually a pretty helpful one that I ran into while trying to demonstrate the problem with config files previously.  Now when you use config file you can store all your connections in a single file and SSIS will actually run the packages successfully if you do not have all those connections in the package.

You actually do still see an error but not until you open the configuration manager.  Again my preference is to use the database storage method for configurations but if you’re using this option I hope this helps.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.


1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...


1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.


360 reads