ADF Copy Mapping Error mapping csv to DB Table

Mike Kiser 1,531 Reputation points
2021-03-14T04:14:36.247+00:00

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

Error
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,'

77377-image.png

77448-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,487 questions
0 comments
Accepted answer
  1. Nasreen Akter 10,736 Reputation points
    2021-03-14T15:17:16.76+00:00

    Hi @Mike Kiser , there is a similar thread https://learn.microsoft.com/en-us/answers/questions/114567/error-when-trying-to-copy-data.html, would you please check the above link. This might help you with the issue. Thanks!

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest