ADF Copy Mapping Error mapping csv to DB Table

Mike Kiser 1,531 Reputation points

Hi! @Nasreen Akter @MartinJaffer-MSFT @HimanshuSinha-msft

I am getting the following error in my Copy Activity; the source is a csv file and the column statusCode is in the CSV file and in the Sink which is a SQL Server DB Table. Can you please give me any suggestions on where else to look? I have tried everything. Thanks! Mike Kiser

Screenshots below showing the source (csv file which has statusCode) and the DB Table which has the statusCode column. I have no idea on this one....thanks

Operation on target Copy Success Factors Emp Data To DBv2 failed: ErrorCode=UserErrorInvalidColumnMappingColumnNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'statusCode' specified in column mapping cannot be found in source data.,Source=Microsoft.DataTransfer.ClientLibrary,'



Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,183 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nasreen Akter 10,656 Reputation points

    Hi @Mike Kiser , there is a similar thread, would you please check the above link. This might help you with the issue. Thanks!

0 additional answers

Sort by: Most helpful