question

Kira-22 avatar image
0 Votes"
Kira-22 asked SumanthMarigowda-MSFT edited

Copying files while keeping their original formats ADF

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.

azure-data-factory
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your response.

But this didnt work out for me because I am copying files of different formats both DAT and CSV. could you please tell me why I am getting this error with csv files : 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 have checked my source files there is no empty column.

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered

Hello @Kira-22,
Thanks for the ask and using the Microsoft Q&A platform .
Have you tried to copy file select the "Binary format" ? you should be ablew to copy the file as is . Read

https://docs.microsoft.com/en-us/azure/data-factory/connector-ftp#supported-capabilities

  • Copying files using Basic or Anonymous authentication.

  • Copying files as-is or parsing files with the supported file formats and compression codecs.
    -

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members


https://docs.microsoft.com/en-us/azure/data-factory/format-binary

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.