none
Comparing two SSIS Packages? RRS feed

  • Question

  • I'd like to know how people out there are comparing ("diffing") their DTSX files.

     

    Using XML file compare doesn't seem to work, because the package XML appears to be arbitrarily ordered and reordered by the designer in Visual Studio.

     

    ApexSQL is supposedly planning to have a tool available in Q3, but even their product page does not seem too hopeful: "Compare and Document SSIS Packages (may be released with ApexSQL Doc and ApexSQL Diff in Q3)"

     

    I remember seeing a CodePlex project that was hoping to address this and other issues, but it was in its infancy, and I can't seem to locate it today.

     

    I'm thinking of starting to write my own package compare tool that will work with the SSIS .NET API, but this seems like it's going to be a ridiculous amount of work and an exercise in pain, and it seems unlikely that I will make the time to target anything more than the specific portions of the package model that I really need.

     

    So if anyone out there has words of wisdom to share, I'd love to hear it. And if (dare I get my hopes up?) have a URL to share, I'll buy you a beer at TechEd in Orlando week after next.

     

    Thanks in advance!

    Thursday, May 24, 2007 7:57 PM
    Moderator

Answers

  • I try not to Smile

     

    Usually I use a text difference tool and deal with the headaches of elements being in different order.

    Sunday, May 27, 2007 6:52 PM
    Moderator

All replies

  • No words of wisdom to share, but I agree on the need for this kind of tool. We've been looking into rolling our own tools as well, but creating anything of general applicability would be a major project.
    Friday, May 25, 2007 6:54 AM
  • I don't know if there is a clever way of comparing packages. Perhaps you should open a suggestion in SQL Server connect site

     

    http://connect.microsoft.com/site/sitehome.aspx?SiteID=68

     

    [Microsoft follow-up]

    Saturday, May 26, 2007 10:08 PM
    Moderator
  • Thanks for the feedback, Rich and Rafael. I'll definitely post this as a suggestion in Connect, but...

     

    Is no one out there (or more specifically, no one here on the SSIS forums) doing anything to compare or diff SSIS packages? I honestly wasn't expecting anyone to say "oh yeah, I use XXX tool, it does a great job" but I was expecting something...

     

    To take this thread in a somewhat different direction, if I were to start a CodePlex project with the aim of developing a package diff utility based on the SSIS object model, would anyone else be interested in contributing? I'll bet I'm not the only SSIS ETL guy out there with a C# background...

    Sunday, May 27, 2007 3:25 PM
    Moderator
  • Rather than starting a new project, would you be interested in rolling this into BIDSHelper? http://www.codeplex.com/bidshelper

     

    Sounds like the type of functionality we are interested in. Though I think having this available outside of BIDS as well would be handy.

    Sunday, May 27, 2007 6:24 PM
    Moderator
  •  jwelch wrote:

    Rather than starting a new project, would you be interested in rolling this into BIDSHelper? http://www.codeplex.com/bidshelper

     

    Sounds like the type of functionality we are interested in. Though I think having this available outside of BIDS as well would be handy.

     

    Thank you!

     

    This was the CodePlex project I mentioned in my original post - I stumbled across it once, but could not find it again when I started this thread here.

    Sunday, May 27, 2007 6:35 PM
    Moderator
  •  jwelch wrote:

    Rather than starting a new project, would you be interested in rolling this into BIDSHelper? http://www.codeplex.com/bidshelper

     

    Sounds like the type of functionality we are interested in. Though I think having this available outside of BIDS as well would be handy.

     

    So... what are you using to compare packages, today?

    Sunday, May 27, 2007 6:36 PM
    Moderator
  • I try not to Smile

     

    Usually I use a text difference tool and deal with the headaches of elements being in different order.

    Sunday, May 27, 2007 6:52 PM
    Moderator
  •  jwelch wrote:

    I try not to Smile

     

    Usually I use a text difference tool and deal with the headaches of elements being in different order.

     

     

    Well, it's good to know that great minds do indeed think alike.

    Sunday, May 27, 2007 7:22 PM
    Moderator
  • Can I just add my voice to the need for such a tool. I still use DTS Compare for our 2000 installations and something similar for SSIS would be of great use.
    Tuesday, September 4, 2007 1:19 PM
  • Our Visual Studio extension has been deployed in March 2017 to Visual Studio Marketplace. It is called SSIS Compare and Merge Tool. You can install it using Tools menu than Extensions and updates and search for online extensions or download and install the .VSIX file from Visual Studio Marketplace (VS2015: https://marketplace.visualstudio.com/items?itemName=TamasTIPost.SSISCompareMergeTool-18170 , VS2013: https://marketplace.visualstudio.com/items?itemName=TamasTIPost.SSISCompareMergeTool). Reviews and feedback are appreciated.

    Update: 

    We found the proper solution, so SSIS Compare Tool for VS2015 is working fine.

    Wednesday, May 31, 2017 8:30 AM