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.


Thursday, 11 February 2021

Integrating data to Dynamics GP from KingswaysSoft which sits on SSIS

Scenario: 

You create a map and the resulting errors are to be written to a sql table via use of the OLE DB connector, so that triggers can be executed in SQL so other records can be updated to remove your failed lines as necessary due to KingswaySoft not playing by the rules of GP. 

 

Issue:  

SQL Table Trigger does not run when the records are inserted from Kingswaysoft. 

SQL Table Trigger only runs when the records are inserted through SQL. 

 

Resolution: 

Right click on the Ole DB output,  Go to the Advanced Editor , navigate to Component Properties of the OLE DB connector and change Access Mode from "OpenRowset using FastLoad" to "OpenRowset"