Hello everyone,
I am trying to copy files from an ftp to a azure blob storage, my problem is that the files are in DAT , CSV formats. When DAT files are copied they are transformed into txt files but I would like to keep their original format.
on the other hand, CSV files wont copy and I get this error : Failure happened on 'Sink' side. ErrorCode=DelimitedTextColumnNameNotAllowNull,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The name of column index 17 is empty. Make sure column name is properly specified in the header row.,Source=Microsoft.DataTransfer.Common,'
I hope i can get an answer to my issue, I am still new to azure data factory.
Thank you.