SSIS - Project Versioning (Project Deployment in SSIS)

Project Versioning in Denali:

Was exploring Denali CTP1, now we can deploy Project to SSISDB Catalog.
Each time we will deploy the project to SSISDB, the project will be saved as new version.
We can see which version we are using currently by checking the properties of project and we can restore any previous version that we want.

How to check version number or project deployed to SSISDB

How to check and restore to previous versions of SSIS Project in SSISDB

**If we don't have Team Foundation Server(TFS) or VSS then this feature is good for version controlling.
**Could not find how to label each of the version or insert some details about project or comments during deployment.


link :

http://social.technet.microsoft.com/wiki/contents/articles/projects-in-sql-server-denali-ctp1-ssis.aspx

2 comments:

  1. Nice one Aamir.
    Actually I came to know abt your blob from your reply to my post @ MSDN SSIS thread (http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/791b0869-483d-4b55-a9b7-d53dc30ad625). Nice blog :)

    Actually the SSIS development require to manage multiple VS/BIDS... even If I want to work on VS2010 I still need BIDS 2005 and BIDS 2008 for 2005 and 2008 SQL Servers. It is a big pain. So do we have any solution for this during Denali release?

    ReplyDelete
  2. Nice Blog!
    Very useful information with easy interface.

    ReplyDelete