Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Azure Data Factory - Copy Command : Bulk load failed due to invalid column value in CSV data file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 1%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
M, Murugeswari (Cognizant)
461
Reputation points
Hi,
I am loading records from delimited file in storage account to a table in dedicated sql pool
I am facing issue with 6 records.. I am getting error stating "Bulk load failed due to invalid column value in CSV data file". But those records value were correct.. Validated datatype, row and column delimeters. Kept the default row delimeter [ \r,\n,\r\n] in source settings of ADF Can anyone please let me know what is the issue
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
-
Vinodh247-1375 43,181 Reputation points Volunteer Moderator2023-02-26T11:56:14.4366667+00:00 are you using 'autocreate table' option when doing the bulk load? can you check those 6 records again? I believe this might not be the acceptable format for the table. If possible copy and paste those 6 records into a new table with a different data-type.
-
M, Murugeswari (Cognizant) 461 Reputation points
2023-02-27T05:02:01.96+00:00 The table is already created in synapse dedicated pool with correct datatypes
The column is varchar and i believe it should accept all string characters
And I am using Copy command to do the operation
Sign in to comment
Sign in to answer