SSIS SFTP Connection - The connection was closed by the server - Failed on upload / download or middle of transfer

Problem:

When you use ZappySys SSIS SFTP Task Sometimes you might face below error at runtime for SFTP Upload or download operation. Test connection might work but runtime fails.

"UploadFile failed. The connection was closed by the server

Possible Cause

If you tried to upload 4-5 MB file using FileZilla or other Clients couple of times and each time it works then check next paragraph, if FileZilla fails with connection abort error that means its possibly issue from FTP Service Provider and nothing from ZappySys side.

Your SFTP Server might be expecting Key Size greater than suggested or Default Package Size used by ZappySys is too big for SFTP Server to handle or may be other reason not covered in this article. 

Possible Solutions

Try following solutions see it works

1. Contact your FTP Service Provider see they can share more information about such error.
2. Set Minimum Server Key Size setting to 0 (This will use default setting of component i.e. 1024 is default in most cases)
3. Save Connection and run your package again see this helps.

If your package still fails after setting Key size to 0 then try one more change below see it helps.

1. Check Use Small Packages Option
2. Save package and run it again see error goes away

If none of above helps then contact ZappySys Support for more help

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/