FTPS Connection




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

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

Looking for older releases? Check here.

Overview

FTPS Connection Manager is SSIS Connection Manager for establishing FTP over SSL connections. Use the API to build components based on FTPS Connection Manager.

Setup

Use the FTPS Connection Manager dialog to specify properties for connecting to an FTP over SSL server. The configuration dialog has server and proxy settings.

Server Options

Connection Type

Specify connection type. This parameter has the options listed in the following table.

Value Description
Unsecure Unsecured FTP connection.
ExplicitSSL Use Explicit SSL FTPS.
ImplicitSSL Use Implicit SSL FTPS.
ExplicitTLS (1.3 SR-1) Use Explicit TLS FTPS.
ImplicitTLS (1.3 SR-1) Use Implicit TLS FTPS.
Host

Specify the name or IP address of the FTPS server.

Port

Specify the port number on the FTPS server to use for the connection. The default value of this parameter is 21.

User name

Specify user name to access the FTPS server.

Password

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

Time-out (secs)

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

RetainSameConnection (1.3 SR-5)

Specify if all clients should use the same connection. This parameter 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.3 SR-5)

Password Protection (1.3 SR-2)

Note: Starting from 1.4 SR-3 this option is no longer needed because it is automatically determined.

Specify OTP S/Key password protection. This parameter has the options listed in the following table.

Value Description
None No password protection.
MD4 MD4 password protection.
MD5 MD5 password protection.
Certificate file (1.3 SR-5)

Select client certificate file.

Certificate password (1.3 SR-5)

Select client certificate password.

Data transfer passive mode (1.3 SR-5)

Specify what mode to use for data connections. This parameter has the options listed in the following table.

Value Description
True Use passive mode for data connections (default).
False Use active mode for data connections.
Ignore server IP in passive mode (1.4 SR-2)

Specify if the reported server address in passive mode is ignored. This parameter has the options listed in the following table.

Value Description
True The reported server address is ignored. Use this setting when when the IP address is unroutable.
False The reported server address is not ignored (default).
Verbose log (1.5)

Specify verbose log file name for investigating FTPS connection issues.

Use binary transfer (1.5)

Specify files transfer mode. This parameter has the options listed in the following table.

Value Description
True Use binary mode (default).
False Use ASCII mode.
Clear Command Channel (1.5)

Specify command channel encryption. This parameter has the options listed in the following table.

Value Description
True Use clear command channel, after authenticating to the remote server. The data connections are still encrypted. Use this option when you have introspecting firewall, which dynamically opens data ports required by the FTPS.
False Command channel is encrypted (default).
BackendVersion (1.5)

Specify FTPS backend engine in use. This parameter has the options listed in the following table.

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

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

Clear Data Channel (1.6 SR-2)

Specify data channel encryption. This parameter has the options listed in the following table.

Value Description
True Data channel is not encrypted.
False Data channel is encrypted (default).

Proxy Options

Proxy:

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

Value Description
None Proxy not specified
SOCKS4 Use SOCKS4 proxy type.
SOCKS5 Use SOCKS5 proxy type.
HTTP Use HTTP proxy type.
FTPSite Use FTP w/ SITE proxy type. Available only for unsecured connection type.
FTPOpen Use FTP w/ OPEN proxy type. Available only for unsecured connection type.
FTPUser (1.3 SR-1) Use FTP w/ USER proxy type. Available only for unsecured connection 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 parameter is 80.

User name

Specify user name to access the proxy server.

Password

Specify password to access the proxy server.