Skip to content


How to set up a map to use Changes Only / Change Table Data Source to delete records from a SQL Table once imported into GP

Alyson Frost asked 7 years ago
I have a customer that needs to import Customers and Customer Addresses from external staging tables into Dynamics GP.  Once the records are successfully integrated, we’d like to delete them fro mte staging table. 
The documentation is so scattered I am having difficulty figuring out how to set up the Change Table Data source and how to include this with the successful record import.  Is there any step by step instruction or example of setting something like this up?
Patrick Roth Staff answered 7 years ago
The documentation on setting up a change data table is here:
However I don’t think you really want to do this since this isn’t ongoing.  You said you would just put the data In the staging table and then delete when finished.
If it was ongoing (insert/udpates) then a change table would be perfect.
So just set up the change source which sets up a trigger on the target table.
at that point, you would populate the staging table which would populate the change tracking table.  SC will run and then mark off the successful ones automatically.

If you would like to submit an answer or comment, please sign in to the eOne portal.