I am running a Data Factory process to load Delimited File (1.2 GB) into Azure SQL server and it's failing after the Data read reached to 100 mb.
Error:
Error
Operation on target ForEach1 failed: Activity failed because an inner activity failed; Inner activity name: Copy data1, Error: ErrorCode=DelimitedTextIncorrectRowDelimiter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The specified row delimiter
is incorrect. Cannot detect a row after parse 100 MB data.,Source=Microsoft.DataTransfer.Common,'
And the failure point is not consisted first time it failed around 17 million records, second time around 19 million records so it's not consistent to validate the file.
Any help is appreciated.
