I have csv file that I loaded onto my Blob container. These csv files must be processed to a table via my pipeline. It is an external csv file that I do not have control over the layout etc.
I have created a pipeline as well as a folder.
But get the following error message I do not know how to fix it.
{
"errorCode": "2200",
"message": "ErrorCode=UserErrorInvalidDataValue,'Type=[login to view URL],Message=Column 'Field1' contains an invalid value 'Source=[login to view URL],''Type=[login to view URL],Message=Type of value has a mismatch
n Field1 Column. Expected type is Byte[].,Source=[login to view URL],''Type=[login to view URL],Message=Type of value has a mismatch with column type,Source=[login to view URL],'",
"failureType": "UserError",
"target": "Copy data1",
"details": []
}
Hi,
I am an MS certified Azure architect and have over 5 years of relevant experience in Azure. I have a total experience of over 12 years in MS Technology Stack.
Could you please confirm that the CSV format is fixed or dynamic? Lets discuss over chat further.
Relevant Experience - Azure ADF, Blob Storage, Azure Storage -Table etc
Regards,
RJ
£65 GBP en 3 días
5,0 (1 comentario)
1,8
1,8
6 freelancers están ofertando un promedio de £145 GBP por este trabajo
got your requirement let's connect for further discussion find my bio Below
we have team of people who work with Azure and AWS Cloud and On-Premises, Understand client issues and provide them best Cloud / IT infrastructure/security solutions , mostly our deployment on Azure cloud,
Experience: professional with 4 years of experience in IT Support and Cloud Computing technology, and devops practices
Hi, its a simple fix. I faced a scenario like this in Azure Data Factory pipeline in one of my recent projects where the format of source files was variable and fixed it last week. I can implement the same fix for you.
Hit me a message to discuss this further.
P.S. I am a Microsoft Certified Azure Data Engineers and solve complex data problems for my clients for a living.
Thanks
Sameet
Dear Bid Poster,
Thanks for the opportunity.
Given these requirements, I am certain that I have the necessary skills to successfully do the job adeptly and perform above expectations.
I am expert with Azure Cloud, I got your error. I am interested in your project please message me that we will discuss more.
Thanks,
Naeem Ahmed