SQL Query to move only those records which are not present in the CRM organization

(0) Share

Report

Posted on by Anant

255

Hi all,
i have a scenario where i have to migrate data from SQL server database to CRM Online. While executing the SSIS package, it is throwing an error- some Duplicate records already present in the CRM Online.
Now, I want to move only those data that are not present in the Online CRM.
Need help..!!

*This post is locked for comments

All responses (1)

Answers (0)

David Jennaway 14,063 on at

Like (0)

Report
RE: SQL Query to move only those records which are not present in the CRM organization

One way to do this is to export the current records from CRM Online to a SQL table (e.g. CurrentCrmRecords). You can then either:

Modify your existing query to omit records that are in this CurrentCrmRecords table (you can use a NOT IN or NOT EXISTS operator)

Or, use an SSIS lookup transformation that has the CurrentCrmRecords table as the source, and only migrate data from the No Match output

In either case you need to be careful if there are nulls in the fields that are used to identify duplicates. If nulls cannot trigger duplicates, then the easiest way to handle this is to exclude records with null values from the export from CRM