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)

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.

PassiveMode (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.

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.