sql - Azure 数据工厂 V2 复制数据问题 - 错误代码 : 2200 An item with the same key has already been added

Question

我正在尝试将数据从 csv 文件复制到 Azure sql，但仅在管道部署期间出现独特的错误。我使用的是普通复制数据

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

请帮忙解决

Answer 1

上述错误是由于 csv 文件中存在重复的列/标题造成的。异常消息指出已添加具有相同键的项目，即重复列可能会添加到字典中，并且已引发异常。