BI Daily : Version Control SSIS Packages
SSIS packages has great limitation, if one wants to do a version control and the compare it with two different version of the packages. Version control can be done using any standard version control tools, but when you try to compare it, one can only compare the XML of the packages and it's really very tedious to make out the difference.
In a development environment for example in a typical data warehouse load and refresh ETL projects, lots of packages gets developed and having version control on these packages becomes very necessary as the development continues, and also it remains important across various environments like DEV, QA, PROD etc.. for making sure the correct version of the package is in place in the targeted environment.
Shamelessly enough, but this time I am going to blow my own horn. This article is authored by me, and it describes one of the way that I have practiced for the above described purpose. There are almost no out of the box features in BIDS or TFS that can help for the issue in question, and the way described in this article is one of the ways to cater solution to this issue.
URL: http://www.mssqltips.com/tip.asp?tip=1892