That worked!! Thank you! Last question for you. I have a serverless SQL server which takes time to turn on from the first time it is queried. What can I do in the pipeline to turn on the server?
Error when trying to copy data
Christopher Aghassi
16
Reputation points
I am getting this error even though I have checked the source data and the column is there. {
"errorCode": "2200",
"message": "Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidColumnMappingColumnNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'first_name' specified in column mapping cannot be found in source data.,Source=Microsoft.DataTransfer.ClientLibrary,'",
"failureType": "UserError",
"target": "Patient Data",
"details": []
}