Hi there,

There are files coming from the partners in csv format. They upload it on FTP and a moveit job moves them to SFTP location. When the ADF uses the SFTP linked service to read the file it errors out with the following error.  This file does not have any data issue. 

However if I use the Azure blob storage and upload the file there and read it using ADF’s Azure blob storage linked service it gets processed perfectly. 

Could you please help me understand why I am getting the error only when processing the file using SFTP? 

Error while using SFTP – 

ErrorCode=DelimitedTextMoreColumnsThanDefined,’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error found when processing ‘Csv/Tsv Format Text’ source ‘TodaysFile_06_18_2024.csv’ with row number 88186: found more columns than expected column count 25.,Source=Microsoft.DataTransfer.Common,’

​Hi there,There are files coming from the partners in csv format. They upload it on FTP and a moveit job moves them to SFTP location. When the ADF uses the SFTP linked service to read the file it errors out with the following error.  This file does not have any data issue. However if I use the Azure blob storage and upload the file there and read it using ADF’s Azure blob storage linked service it gets processed perfectly. Could you please help me understand why I am getting the error only when processing the file using SFTP?  Error while using SFTP – ErrorCode=DelimitedTextMoreColumnsThanDefined,’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error found when processing ‘Csv/Tsv Format Text’ source ‘TodaysFile_06_18_2024.csv’ with row number 88186: found more columns than expected column count 25.,Source=Microsoft.DataTransfer.Common,’    Read More

​