duplicate key violation error

Question

I'm getting a duplicate key violation error when importing data. There aren't any duplicate keys in the source.

Answer 1

Hi @Shiela E 2021 ,

Please try to redirect error rows from your destination to any file or table o check what's the exact rows caused the issue.

You may also use sort Transformation Task to check the value.

Reference: https://www.sqlcoffee.com/Troubleshooting146.htm

Also someone mentioned that the error may cause by that your source table columns are case sensitive but your destination columns are not. To solve the issue, just recreate your destination table with columns case sensitive.

i-am-using-ssis-and-i-am-getting-this-error-violation-of-primary-key-constraint

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.