CODEWITHSUNDEEP
sqlsql-serverazureazure-data-factory
Gowthaman K
Gowthaman K

Reputation: 11

Azure data factory V2 copy data issue - error code: 2200 An item with the same key has already been added

I am trying to copy data from a csv file into the Azure sql but I am getting an unique error only during the deployment of pipeline. I am using a normal copy data

{ "errorCode": "2200", "message": "ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property '' is invalid: 'An item with the same key has already been added.'.,Source=,''Type=System.ArgumentException,Message=An item with the same key has already been added.,Source=mscorlib,'", "failureType": "UserError", "target": "Copy data1", "details": [] }

Kindly help to solve

Upvotes: 1

Views: 1923

Answers (1)

hagarwal
hagarwal

Reputation: 1163

The above error is due to a duplicate column/header in the csv file. The exception message states An item with the same key has already been added that is the duplicate column might be getting added to a dictionary and the exception has been thrown.

Upvotes: 0

Related Questions