SSIS Compare & Merge Tool

Introduction

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.

Updates

28/11/2024

• Modified pre-requisite

05/11/2024

• Support of Visual Studio 2022 x64 and arm64 (arm64 not tested)

07/10/2024

• Change version range for SSDT prerequisite

13/08/2024

• TFS support removed
• Support Visual Studio Community Edition as well
• 64bit and ARM support prerequisites for Visual Studio 2022 support

25/03/2020 Fix "Must specify valid information for parsing the string" error

19/01/2020 Remove SSDT prerequisite

22/08/2019 Fix Git and TFS support, async package processing in VS 2015 and above.

25/06/2019 Readd Visual Studio 2015, 2017 support.

10/06/2019 Visual Studio 2019 support.

03/06/2019 Fix invalid path GIT issue. To request trial license or in case of trouble, contact us using info@dotnetsoft.eu or +36709498665. Tested with Azure DevOps.

24/01/2019 Add Getting started guide, URL, release notes.

13/11/2018 Fix missing dll error when compare packages

05/11/2018 Extend supported Visual Studio targets.

21/08/2018 SSIS Compare & Merge Tool is available for Visual Studio 2017 (beta). We'll also test it in coming days! Enjoy!

20/08/2018 We finally fixed parsing package error. If you have still issues to compare package, send us an e-mail to info@dotnetsoft.eu.

21/07/2018 We fixed some issues regarding deserialization error. Only root element appeared. If you are still experiencing this issue, don't hesitate to contact us.

04/06/2018 We solved all main issues and reinitialized trial period. Use the extension with full functionality and request license if it fits your business needs.

Coming Features

1. Compare between GIT repository, working copy, SQL Server Integration Catalogs
2. Export differences into XML file

Known Issues

1. DLL incompatibility error in Visual Studio 2017 and previous versions

The new way

There is a new, simpler way to compare SSIS packages:

1. Right click on the dtsx package in solution explorer, SSIS Compare Tool menu and compare.

2. Select source and destination files. TFS and source control will be automatically detected. Press OK.

3. 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
• Variables

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.

Trial period

There is a 30 days trial period to test our extension with full functionality to see how useful it is.

Licensing and pricing

Our licensing strategy is flexible, let's see how to scale license to fit your requirements. Prices has been defined based on a win-win situation. Spare 1 hour in every month with SSIS Compare & Merge Tool and enjoy its profit (in case of compare).

Compare or merge license

Compare license allows you to compare SSIS packages. If you don't create developer branch or you usually don't need to merge SSIS packages, choose compare license.

To be able to merge SSIS packages choose merge license. It contains compare feature as well. Spare much more time and much more money, you can take care on other tasks.

Single or volume license

The single license is restricted for a single user. The only who can use our extension is the user of the license.

To avoid the huge amount of license keys, contact us to order volume license, there is no restriction regarding users but the amount of installations.

Pricing

Table below shows the prices of the extension (tax excluded).

*: Merge feature will be available soon

**: Volume license price depends on the volume you require. You'll get discount, feature requests will be prior.

Troubleshooting

Experienced issues can be reported by e-mail: info@dotnetsoft.eu or using Q&A section. Starting Visual Studio or SQL Server Data Tools with /log switch SSIS Compare & Merge Tool will log into Visual Studio Activity log, search for <source>[SSISCompareTool]</source> expression.

info@dotnetsoft.eu | Phone call/Viber/Whatsapp: +36 70 949 8665