How to move files to SFTP using SSIS

[daniel]

Introduction

This guide will walk you through transferring file(s) using SFTP in SSIS.

Prerequisites

• SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from this site.

Steps

1. Right-click on Connection Managers, select New Connection…, then ZS-SFTP.

2. In the Connection Manager UI, select SFTP - SSH File Transfer Protocol, enter your Hostname, and select Logon. Enter your Username and Password. ![SFTP connection option
   

   

3. Drag and drop the Secure FTP task from the toolbox onto the Control Flow. Configure the task by providing the action “Move FTP file(s)”, the necessary connections, the source file(s) path, and the destination folder.
   

   

4. Run the package, and the file transfer should proceed seamlessly.

Conclusion

Following these steps, you can easily configure our SFTP component in SSIS. For further assistance or inquiries, contact our support team via chat on our website

Reference

For more detailed information, refer to our SSIS SFTP Task (Secure FTP, FTPS) article.v