SSIS Compare & Merge Tool
SSIS Compare & Merge Tool has been designed based on 10+ years SSIS development experience. It is very useful to compare and merge SSIS (DTSX) packages. DTSX file content changes while opening and saving it without any modification. Moving graphical objects also causes file changes. Version control will mark these files as changed. Unlike existing text compare tools we are processing packages and compare them as .NET objects. This procedure ensures that fake differences aren't highlighted, it's easy to decide changes should be commited into version control system or undo it. Compare files in working copy with specific version in repository works on the fly, there is no need to check out them into a different location.
- Finetune comparison
- Merge feature
- 3rd party component support
- DLL incompatibility error in Visual Studio 2017 and previous versions
The new way
There is a new, simpler way to compare SSIS packages:
Right click on the dtsx package in solution explorer, SSIS Compare Tool menu and compare.
Select source and destination files. TFS and source control will be automatically detected. Press OK.
Now you will see both packages in tree views:
- There is no difference*:
* Tree nodes highlighted with yellow doesn't have object name property so currently it shows as difference
- The packages are different:
The tree view is similar to the Package Explorer:
If you are still using a tool like below, try our extension.
Tips and tricks
If you're interested only in logical changes, check the following root elements:
- Executables (Control Flow and Data Flow elements)
- Connection Managers
Design changes affects DesignTimeProperties.
Attribute values are displayed in tooltip, right click on the treenode to view value in a pop-up window.
Based on customer feedback warning windows might appear during comparison. 3rd party component handling should be implemented to avoid them, we'll redirect those messages temporarily into ActivityLog.