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"