How to upload / download files to FTP in parallel using SSIS SFTP Task

In this post, we will show you simple technique to upload/download files to FTP server in SSIS using multiple threads (parallel file upload /download). We are going to use zappysys SSIS Secure FTP Task.

You can split your files across multiple tasks like below. You can create a single connection and reuse for multiple tasks but in rare cases, you may see a problem with some servers. If you notice connection conflict then try to create separate connection managers as below. However first try to create just one connection manager and reuse it across multiple tasks see that works for you.

Articles about SSIS Secure FTP Task

 https://zappysys.com/blog/ssis-sftp-task-examples-upload-download-move-delete-files-folders/

https://zappysys.com/blog/category/ssis/tasks/ssis-sftp-task/

About SSIS SFTP Task (Secure FTP, FTPS)

SSIS SFTP Task can perform many operations using SFTP, FTP/SSL (i.e. FTPS) or Classic FTP Protocol. It supports many advanced options and various authentication mechanism (e.g. NTLM, Kerberos, Client Certificate, Private Key).

There are many FTP/SFTP solutions in the market including many unsupported open source libraries. But if you are serious about security and production ready product then you can trust ZappySys SFTP task. We’ve invested heavily to maintain quality and security. We keep our libraries up-to-date and patch any ongoing vulnerabilities.

 

There are many FTP/SFTP solutions in the market including many unsupported open source libraries. 
But if you are serious about security and production ready product then you can trust ZappySys 
SFTP task. We’ve invested heavily to maintain quality and security. We keep our libraries up-to-date 
and patch any ongoing vulnerabilities.