If you see “Operation failed due to a SQL Integrity violation” error while data import in Dynamics 365 CE then don’t be afraid 🙂 it is just referring to duplicate record for the same unique number like Order number, case number, quote number or invoice number. Correct the unique number format and try data import again, hopefully issue will be resolved.
Simply Dynamic 