This content originally appeared on DEV Community and was authored by Daniel ZS
Introduction
Need to automate file transfers in your SSIS packages? The ZappySys SSIS PowerPack includes an SFTP Task that allows you to connect to SFTP, FTPS, or FTP servers in just a few clicks — no code required.
This guide provides a quick overview of what you can do with the ZS SFTP Task and how to set it up in seconds.
What you can do with the SSIS SFTP Task
- Connect using SFTP, FTPS, or Classic FTP
- Upload or download files using wildcards
-
Use advanced security options:
- Private keys
- SSL/TLS
- Proxy
- Client certificates
-
Perform common file operations:
- Delete files or folders
- Rename files
- Check file size or date
- Get file list or metadata
How to set up the connection
- In Visual Studio (SSDT), right-click under Connection Managers
- Select New Connection > ZS-SFTP
- Choose the protocol: SFTP, FTP, or FTPS
- Enter your credentials:
- Click Test Connection
- Once verified, click OK to save
You can now use this connection inside any SFTP Task in your package.
Want the full guide?
Seeking a comprehensive walkthrough with step-by-step instructions, screenshots, and expert tips?
Read the full tutorial on how to connect to SFTP in SSIS
This content originally appeared on DEV Community and was authored by Daniel ZS