Error Resolution

NishimuraChinatsu-9854 756

Hello.
I get an Error at the copy activity and I don't know how to solve it.

I have tried importing the schema, etc. with mapping, but the Error cannot be resolved. The data is still displayed in the data preview, etc.

{
"errorCode": "2200",
"message": "ErrorCode=UserErrorInvalidColumnMappingColumnNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'material_cd' specified in column mapping cannot be found in source data.,Source=Microsoft.DataTransfer.ClientLibrary,'",
"failureType": "UserError",
"target": "Copy data1",
"details": []
}

I would like to know.

Nandan Hegde 31,511 Reputation points MVP

2022-07-13T05:26:39.893+00:00

Hey,
Can you please specify what is the source in your copy activity?
NishimuraChinatsu-9854 756 Reputation points

2022-07-13T05:37:09.04+00:00

Excuse me. What do you mean?
Nandan Hegde 31,511 Reputation points MVP

2022-07-13T05:42:56.353+00:00

It means your source is Azure data lake and based on the error message it seems that there is no column with name material_cd in the source file.
would it be possible for you to share the screenshot of the headers of the file which you are using as it might help us further.
NishimuraChinatsu-9854 756 Reputation points

2022-07-13T05:51:42.733+00:00

Thank you for your reply.
How is it?

Share via

Error Resolution