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.
Parameters
Server
Use the Server page of the FTPS Connection Manager dialog to specify properties for connecting to an FTP over SSL server.
- Test Connection
- Confirm connection manager configuration by clicking Test Connection.
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. Specify the name or IP address of the FTPS server.
Specify the port number on the FTPS server to use for the connection. The default value of this parameter is 21.
Specify user name to access the FTPS server.
Specify password to access the FTPS server. Specify arbitrary value for anonymous account.
Specify the number of seconds before timing out session connect. The default value of this parameter is 60 seconds.
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).
Advanced (1.3 SR-5)
Use the Advanced of the FTPS Connection Manager dialog to specify properties if the remote server configuration is different from the default.
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. Starting from 1.4 SR-3 this option is no longer needed because it is automatically determined.Select client certificate file.
Select client certificate password.
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. 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). Specify verbose log file name for investigating FTPS connection issues.
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. 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). 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). This parameter is not visible in the connection manager dialog.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
Use the Proxy page of the FTPS Connection Manager dialog to specify properties if your server is behind firewall.
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. Specify the name or IP address of the proxy server.
Specify the port number on the proxy server to use for the connection. The default value of this parameter is 80.
Specify user name to access the proxy server.
Specify password to access the proxy server.
Knowledge Base
- Error Message: Not a valid PFX data
- Where can I find the documentation for the FTPS Connection?
- What connection type and port should I use with the FTPS connection?
- Is there a predefined component for the SFTP service "BrickFTP" (REST API)?
- Error Message: Command not implemented for that parameter (504). (Rebex.Ftp)
What's New
- New: Support for TLS 1.3.
- New: Support for Curve25519 elliptic curve algorithm.
- Fixed: Failed with error "Ephemeral Diffie-Hellman prime received from the server is considered weak" (Thank you, Michael).
- Fixed: File Transfer Task failed with error "The requested operation is not supported" (Thank you, Dave).
- New: Support for TLS 1.1 and 1.2.
- New: A new parameter ClearDataChannel to specify if data channel is secured (encrypted).
- Fixed: Failed with "Already logged in (530)" error when connecting to certain servers with client certificate (Thank you, Ulia).
- Fixed: Failed to send QUIT command at session end when using new backend.
- Fixed: Manager can now automatically determine if password has to be OTP S/Key protected. Manual specification is no longer required.
- New: A new parameter PassiveIgnoreAddress to specify to ignore provided IP address in passive mode. This parameter is useful when the remote server is incorrectly configured.
- Fixed: Failed to upload a file in resume mode.
- Fixed: Failed to parse correctly Unix and Windows file names, which included two or more spaces.
- New: Support for client certificates.
- Fixed: Failed to to connect to Tumbleweed SecureTransport server.
- New: A new parameter RetainSameConnection to use same connection in client components.
- New: A new parameter PassiveMode to switch between active / passive FTP. The new parameter can be set by right-clicking on the connection manager and selecting Properties.
- Fixed: Failed to parse remote file information after incorrect detection of remote system.
- Fixed: Failed to parse file information provided by Connect:Enterprise UNIX FTP server.
- New: Support for processing remote file list containing only names.
- Fixed: Failed to transfer files in implicit mode with FileZilla Server.
- Fixed: Failed to parse Unix file information with missing file group field.
- Fixed: Failed to complete download when downloading 30MB or larger file to a network share (Thank you, Tom).
- Fixed: When connected to wu-2.6.1 server, the manager incorrectly included sub-folder files as part of specified folder list (Thank you, Amrit and Team).
- Fixed: Failed to parse all remote file date/time formats of Unix-based servers.
- Fixed: Manager constructed incomplete remote file names.
- Fixed: Failed to disconnect from server (Thank you, Mika).
- New: Included support for OTP S/Key MD4 MD5 password protection.
- New: Implemented support for FTP w/ USER proxy type.
- Fixed: Failed to process Windows FTP server files correctly.
- Fixed: Failed to report IO errors (Thank you, Dan).
- Fixed: Failed to connect to certain FTP servers, returning error: No such host is known.
- New: Implemented support for FTP over TLS.
- Fixed: Failed to parse date/time of remote files, when local machine culture was other than English.
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.