Trying to import the records in to CRM on-premise environment (8.2) version. Need to create new contact records with the GUID mapping to the unique id. Exporting the data from another environment. The issue is when I am tried first time to import it using the outbox import wizard it is showing successfully imported all the records. But in the data base the records are not exists. Out of 10000 only 20 to 30 records are exists.
Next time when I tried the import wizard with same input file it is giving “Generic Sql error”. For those 20 to 30 records which was created during the first import giving the duplicate error.
Then I tried using the SSIS package. But it is not working giving “Generic SQL error”. When I am removing the record GUID the records are importing but with GUID it is giving generic SQL error.