FTPS Connection

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 property 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 property 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 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.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 property 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 property 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 property 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 to use binary mode for file transfers.

Clear Command Channel (1.5)

Specify to 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.

BackendVersion (1.5)

Specify FTPS backend engine in use. This property 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 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
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 property is 80.

User name

Specify user name to access the proxy server.

Password

Specify password to access the proxy server.