sridhar 6 Reputation points


We are facing the issue with while copying a file (comma delimited and with a file format PVXXXXX and without extension ) from an SFTP server (LINUX) into Azure using Copy activity from SFTP to Blob.

Below is the error message

If the file is marked as a binary in Linux (I think filetype as 0 as per our SFTP counter part), we are able to copy. but if the file type is mentioned as AscII (filetype as 1) it is failing.

Failure happened on 'Sink' side. ErrorCode=SftpServerNotReturnExpectedDataLength,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error occurred when trying to fetch the SFTP file 'pv112235'. This could be a transient issue and you may rerun the job. If it fails again continuously, contact customer support.,Source=Microsoft.DataTransfer.ClientLibrary.SftpConnector,'

Can you please help here


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,127 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ShaikMaheer-MSFT 31,551 Reputation points Microsoft Employee

    Hi @sridhar ,

    Thank you for posting query on Microsoft Q&A Platform.

    Could you please try below suggestions and see if that helps.

  2. sridhar 6 Reputation points

    The issue got resolved by Microsoft Support: there is an undocumented feature "disableChunking": true that solved the problem which is yet to be released