TFS vs SSIS project versioning

I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit to using TFS?  The answer is Yes!  While Project Versions is a new feature that keeps prior versions of SSIS projects as they are deployed to the server and allows you to rollback to any prior version, it is not a replacement for source control.  Here are some of the limitations of using Project Versions as compared to using TFS:

The bottom line is the best use for Project Versions is to quickly revert to a prior project version if a new version causes issues (a quick rollback).  It is not really a source control solution.

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQLServerPedia Syndication, SSIS, Team Foundation Server. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *