Forum Discussion
duplicate key error in (csv files to mysql database)copy activity azure data factory
HI, I have a problem, when trying to copy data from 1 csv files to another Mysql database with the copy command in Azure data factory (with the fault tolerance enabled) I'm getting a duplicate ...
I am facing the exact same issue. Getting this error, when the values in the CSV file are all unique...
"Operation on target Copy_kw4 failed: Failure happened on 'Sink' side. 'Type=MySql.Data.MySqlClient.MySqlException,Message=Duplicate entry '1234IORDFT' for key 'gst.PRIMARY',Source=MySqlConnector,''Type=MySql.Data.MySqlClient.MySqlException,Message=Duplicate entry '1234IORDFT' for key 'gst.PRIMARY',Source=mscorlib,'"