Monday, 1 March 2021

KingswaySoft SSIS Error at Merge Join - An item with the same key has already been added

Issue

  • You are trying to join two sets of data using a Merge Join. 
  • No matter what you try you get the error "An Item with the same key has already been added"

 

Background:

  •           It works well using Visual Studio 2017, but your same map design does not work on Visual Studio 2012.

 

What you may have tried and did not work:

  •          Deleting and recreating map
  •          Renaming connections and every other node in VS
  •          Restarting your server

 

What worked for me:

  •          Add a two-layer sort for both outputs before the merge join as the error is complaining about a key.