Post reply

compare difference of versions of SSIS package

  • February 23, 2012 at 10:53 am

    #150835

    I often need to compare what is the difference of a ssis package with a previous version.

    Is there a way to do that?

    Thanks

  • March 13, 2012 at 8:22 pm

    #1458971

    Yes.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 13, 2012 at 8:31 pm

    #1458972

    opc.three (3/13/2012)

    Yes.

    What is it?

  • March 13, 2012 at 9:11 pm

    #1458976

    Are you using a version control system to manage your SSIS packages?

    Are you deploying packages to the file system or to msdb?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 14, 2012 at 10:02 am

    #1459325

    opc.three (3/13/2012)

    Are you using a version control system to manage your SSIS packages?

    Are you deploying packages to the file system or to msdb?

    Using version control subversion. Packages are deployed to file system.

    I don't see there is an option in version control to compare difference of SSIS packages

  • March 14, 2012 at 10:10 am

    #1459331

    sqlfriends (2/23/2012)

    I often need to compare what is the difference of a ssis package with a previous version.

    Is there a way to do that?

    Thanks

    Not easily.. The package is stored as an XML file and *can* change quite a bit without really changing much form the GUI. What I mean by that is the overall text might not change much but where one part is in the XML file can change quite a bit even if the content of that part doesn't. This REALLY messes up text comparison operations..

    However, it is possible at the object model level. and I do think that there has been some work done on that in third-party tools.. I just can't name one off the top of my head.

    CEWII

  • March 14, 2012 at 11:21 am

    #1459385

    Elliott Whitlow (3/14/2012)

    sqlfriends (2/23/2012)

    I often need to compare what is the difference of a ssis package with a previous version.

    Is there a way to do that?

    Thanks

    Not easily.. The package is stored as an XML file and *can* change quite a bit without really changing much form the GUI. What I mean by that is the overall text might not change much but where one part is in the XML file can change quite a bit even if the content of that part doesn't. This REALLY messes up text comparison operations..

    However, it is possible at the object model level. and I do think that there has been some work done on that in third-party tools.. I just can't name one off the top of my head.

    CEWII

    You must get SmartDiff, it is quite handy but only works through BIDS/VS, not through TFS Source Control Explorer: BIDS Helper > SmartDiff

    BIDS Helper Home[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 14, 2012 at 12:29 pm

    #1459436

    Ahh, yes, BIDS Helper.. That is a truly wonderful tool..

    CEWII

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply