Geek Answers Handbook

Best way / tool to compare two SSIS packages

One of the biggest problems with SSIS packages is not allowing you to track changes between versions. Even when compared with nothing, it looks nervous when it comes to comparing two SSIS (DTSX) packages.

Guys, what is your opinion? How do you manage versions and determine the change for each version? If you are asked to compare two SSIS packages, which tool do you use?

+5
source share
2 answers

I appreciated a few tools:

  • BIDS Assistant - seems not actively supported
  • PragmaticWorks SSIS Compare plug-in - this does not support trilateral merging, thick scrollbars with previews of differences (which are a standard diff function these days), and does nothing like you can scan in SSIS for graphical visualization of a function.
  • BeyondCompare 3 with an XML format with a clear file and some regular expressions to ignore version differences, as well as other minor differences that do not affect the comparison "do these packages look the same or different?" http://justgeeks.blogspot.com/2008/01/using-beyond-compare-to-compare-2-ssis.html - see the first comment in a blog post on how to hide minor differences.

BeyondCompare 3 wins for me. If you find additional tools, I will be interested to hear more.

+5
source

You can check out ApexSQL Diff and the SSIS comparison function. It compares the elements and properties of a package, and all the differences can be viewed in the Difference panel, which provides an XML overview of the package.

In addition, this article may be useful: How to compare SSIS packages and the results of export differences

0
source

More articles:


All Articles