SSH Connection

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Questions?

Overview

SSH Connection Manager is SSIS Connection Manager for establishing SSH connections. Use the API to build components based on SSH Connection Manager.


Setup

Use the SSH Connection Manager dialog to specify properties for connecting to an SSH-enabled server. The configuration dialog has server and proxy settings.

Server Options

Host

Specify the name or IP address of the SSH server.

Port

Specify the port number on the SSH server to use for the connection. The default value of this property is 22.

User name

Specify user name to access the SSH server.

Authenticate:

Specify authentication type. This property has the options listed in the following table.

Value Description
By Password User is authenticated with password.

Selecting this value displays the dynamic option Password.

By Key File User is authenticated with private key file, unlocked with passphrase.

Selecting this value displays the dynamic options Key File, Passphrase.

Password

Specify password to access the SSH server. Specify arbitrary value for anonymous account.

Key File

Select private key file to access the SSH server.

Passphrase

Specify passphrase to unlock the private key file.

Time-out (secs)

Specify the number of seconds before timing out session connect. The default value of this property is 60 seconds.

RetainSameConnection (1.3 SR-5)

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value Description
True All clients use same connection.
False Every client use different connection (default).
Test Connection

Confirm connection manager configuration by clicking Test Connection.

Advanced Options (1.5)

Verbose log

Specify verbose log file name for investigating SSH connection issues.

Use binary transfer

Specify to use binary mode for file transfers.

BackendVersion (1.5)

Specify SSH backend engine in use. This property has the options listed in the following table.

Value Description
1 Use legacy SSH backend engine.
2 Use new 1.5 SSH backend engine (default).

Note: This property is not visible in the connection manager dialog.

Proxy Options

Proxy:

Specify proxy type. This property has the options listed in the following table.

Value Description
None Proxy not specified
Tunnel Use tunnel (HTTP) proxy type.
SOCKS4 Use SOCKS4 proxy type.
SOCKS5 Use SOCKS5 proxy type.
Host

Specify the name or IP address of the proxy server.

Port

Specify the port number on the proxy server to use for the connection. The default value of this property is 80.

User name

Specify user name to access the proxy server.

Password

Specify password to access the proxy server.

Related scripts