sftp-adf file copy unzipping error

Vinodh247 13,801

Trying to copy zip file from sftp to adls storage and unzip in the copy activity. The zip has 29 files but it fails everytime after copying and unzipping 8 files, I have toggled between zip,deflate,gzip etc.. but no use. Any help will be appreciated.

Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Upload file failed at path dev/med-file21102\med-file2_20221102.zip/MF2NDC.,Source=Microsoft.DataTransfer.Common,''Type=System.IO.InvalidDataException,Message=Found invalid data while decoding.,Source=System

Nandan Hegde 31,511 Reputation points MVP

2022-10-28T14:32:43.807+00:00

Hey, can you just copy the zipped file from sftp to your local and manually upload it in blob and then try unzipping the file via adf? this is just a debug step
Vinodh247 13,801 Reputation points

2022-10-28T15:03:12.447+00:00

Yes this is a debug step, I will check the option you have listed out...
Vinodh247 13,801 Reputation points

2022-10-28T16:14:15.177+00:00

Yes it works when i manually upload and then unzip using copy activity. But is there any workaround to unzip files when copying straight from SFTP itself? It could save me some time.
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2022-11-03T22:41:39.24+00:00

Hello @Vinodh247 ,

Thanks for the question and using MS Q&A platform.

Wanted to check if you are still blocked or need assistance on this query?
It is strange that it unzips and copy 8 fails before failing. And when you manually copy the zip file to a storage and try to unzip using ADF then there is no issue.
If you have a support plan, please file a support ticket for further investigation. In case if you don't have a support plan, please let me know.

Thank you
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2022-11-08T00:47:22.94+00:00

Hello @Vinodh247 ,

Hello @Vinodh247 ,

We still have not heard back from you. Just wanted to check if you are still blocked or you have already found a solution. In case if your issue is resolved, would you please share the root cause and resolution details here with community as it would help others reading this thread.

Share via

sftp-adf file copy unzipping error