SSIS tutorial: Connecto to SFTP

[Sascha]

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

1. In Visual Studio (SSDT), right-click under Connection Managers
2. Select New Connection > ZS-SFTP
3. Choose the protocol: SFTP, FTP, or FTPS
4. Enter your credentials:
5. Click Test Connection
6. 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?

Пожалуйста Авторизируйтесь или Зарегистрируйтесь для просмотра скрытого текста.

Источник:

Пожалуйста Авторизируйтесь или Зарегистрируйтесь для просмотра скрытого текста.