SSIS Tutorial: How to Configure the SFTP Cipher Algorithms

SSIS Tutorials
,
1

Introduction

When connecting to SFTP servers in SSIS, some servers may require specific cipher algorithms for secure communication. The ZappySys Secure FTP Task supports advanced encryption configurations, allowing you to customize key exchange methods, MAC algorithms, encryption ciphers, and host key validation techniques.

In this tutorial, you’ll learn how to configure SFTP cipher algorithms in the ZappySys Secure FTP connection manager to meet your security or compatibility requirements.

Prerequisites

Steps

Step 1: Open the Secure FTP Connection Manager

  1. Open your SSIS project in Visual Studio (SSDT).
  2. Go to the Connection Managers panel at the bottom.
  3. Select an existing ZP-SFTP connection or right-click to create a New Connection using the ZappySys Secure FTP provider.
    Open SFTP Connection Manager
    Open SFTP Connection Manager1314×450 49.1 KB

Step 2: Access the Encryption Settings

  1. In the Secure FTP Connection Manager, go to the Advanced tab.
  2. Locate the section labeled Encryption Algorithms / Ciphers. This section allows you to customize the encryption handshake with the server.

Step 3: Configure Cipher Algorithm Settings

Here’s a breakdown of each configurable setting:

  • Key Exchange Algorithms: Defines the method for securely exchanging cryptographic keys with the server. Examples:

    diffie-hellman-group14-sha1, ecdh-sha2-nistp256, diffie-hellman-group-exchange-sha256

  • MAC Algorithms: Specifies the Message Authentication Code algorithms used for data integrity checks. Examples:

    hmac-sha2-256, hmac-sha1

  • Encryption Algorithms: Determines which encryption ciphers are used for data transmission. Examples:

    aes128-ctr, aes256-ctr, 3des-cbc

  • Host Key Algorithms: Sets the method for verifying the server’s host key. Examples:

    ssh-rsa, rsa-sha2-256

  • To enable all supported algorithms, enter: any.

You can enter multiple algorithms by separating them with commas without spaces.

Configure Encryption Settings
Configure Encryption Settings720×615 78.9 KB

Step 4: Test the Connection

After configuring the algorithms:

  1. Click the Test Connection button.
  2. Ensure the server supports the algorithms you’ve selected.
  3. If the connection fails, check your server documentation or try adjusting the cipher list.
  4. It’s always recommended to test in a development environment before applying to production.

Conclusion

Using the ZappySys Secure FTP Task, you can fully customize SFTP cipher algorithms to match your server’s security requirements. This ensures compatibility and enhances data protection for secure file transfers. With flexible configuration options and an intuitive interface, ZappySys simplifies secure connectivity in SSIS.

Visit our official page to explore more SSIS components, automation features, and real-time data integration tools included in ZappySys SSIS PowerPack.

References

Contact us

If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.