SFTP Task
The SFTP Component adds SSH-secured file transfer capabilities to your SSIS Package.
Remarks
The SFTP Task adds a complete SFTP client to your SSIS Package that enables it with SSH-secured file download and upload functionality.
SFTP Receive Task
The SFTP Receive Task requires that a single property be set: SSHHost. You may also set an SSHPort if the server is not running on the default SSH port. In order to authenticate with the SSH server, you will need to specify an SSHUser, and either SSHPassword or SSHCert depending upon the SSHAuthMode to be used.
The task will connect to the SFTP server every PollingInterval and list the directory specified by RemotePath. All files that match the FileMask will be downloaded and submitted to the SSIS Package as individual SSIS ADO tables. In order to guarantee that files are not downloaded multiple times, you may set the DeleteMode.
SFTP Send Task
The SFTP Send Task requires both an SSHHost and a RemoteFile. You may also set an SSHPort if the server is not running on the default SSH port. In order to authenticate with the SSH server, you will need to specify an SSHUser, and either SSHPassword or SSHCert depending upon the SSHAuthMode to be used.
The task will connect to the SFTP server whenever it has a message to send. The task will attempt to upload to the specified RemotePath. If Overwrite is set to True, the task will delete or overwrite remote files as necessary to complete the operation.
In order to prevent parallel processing by another application before your upload is complete, you may need to set a temporary upload directory via RemoteTempPath. If the temporary directory is set, the file will first be uploaded to the specified temporary directory, and will be moved to the final destination path once the upload has completed.
Receiver Property List
The following is the full list of the properties of the receiver task with short descriptions. Click on the links for further details.
AfterConnect | A set of FTP-style commands to be executed immediately after connecting to the SSHHost . |
AfterGet | A set of FTP-style commands to be executed after the download. |
BeforeGet | A set of FTP-style commands to be executed before the download. |
Delete | Controls if the remote file is deleted after download. |
DirList | String denoting the name of the variable which contains the last directory listing entries. |
FileMask | Indicates the type of files to download from the SSH server. |
Firewall | A set of properties related to firewall access. |
LocalDirectory | The directory on the local machine where files are downloaded. |
LogFile | The file to write logging information to at runtime. |
LogMode | What information gets logged during component execution. |
Operation | The operation which will be executed by the FTP task. |
Other | Defines a set of configuration settings to be used by the component. |
Overwrite | Whether or not the component should overwrite files during transfer. |
PersistentConnection | Instructs the component whether to keep the connection to the server open. |
RemotePath | The current path on the SSH server. |
RuntimeLicense | Specifies the component runtime license key. |
SSHAcceptServerHostKey | Instructs the component to accept the server host key that matches the supplied key. |
SSHAcceptServerHostKeyAcceptAny | Tells the component to accept any server certificate. |
SSHAuthMode | The type of authentication used by the component. |
SSHCert | The certificate to use for client authentication during the SSH handshake. |
SSHCompressionAlgorithms | A comma-separated list of compression algorithms allowed for this connection. |
SSHHost | The address of the SSH host. |
SSHPassword | The password for SSH password-based authentication. |
SSHPort | The port on the SSH server where the SSH service is running; by default, 22. |
SSHUser | The username for SSH authentication. |
Timeout | A timeout for the component. |
Sender Property List
The following is the full list of the properties of the sender task with short descriptions. Click on the links for further details.
AfterConnect | A set of FTP-style commands to be executed immediately after connecting to the SSHHost . |
AfterPut | A set of FTP-style commands to be executed after the upload. |
Append | Whether or not the component should append data to the RemoteFile . |
BeforePut | A set of FTP-style commands to be executed before the upload. |
Firewall | A set of properties related to firewall access. |
LocalFile | The path to a local file for upload. |
LogFile | The file to write logging information to at runtime. |
LogMode | What information gets logged during component execution. |
Other | Defines a set of configuration settings to be used by the component. |
Overwrite | Whether or not the component should overwrite files during transfer. |
PersistentConnection | Instructs the component whether to keep the connection to the server open. |
RemoteFile | The name of the destination file on the SSH server for uploading. |
RemotePath | The current path on the SSH server. |
RemoteTempPath | A temporary directory on the server to store files before moving them to RemotePath . |
RuntimeLicense | Specifies the component runtime license key. |
SSHAcceptServerHostKey | Instructs the component to accept the server host key that matches the supplied key. |
SSHAcceptServerHostKeyAcceptAny | Tells the component to accept any server certificate. |
SSHAuthMode | The type of authentication used by the component. |
SSHCert | The certificate to use for client authentication during the SSH handshake. |
SSHCompressionAlgorithms | A comma-separated list of compression algorithms allowed for this connection. |
SSHHost | The address of the SSH host. |
SSHPassword | The password for SSH password-based authentication. |
SSHPort | The port on the SSH server where the SSH service is running; by default, 22. |
SSHUser | The username for SSH authentication. |
Timeout | A timeout for the component. |
Config Settings
The following is a list of config settings for the task with short descriptions. Click on the links for further details.
DisableRealPath | Controls whether or not the SSH_FXP_REALPATH request is sent. |
DownloadCacheFile | When set, only new files will be downloaded from the server. |
DownloadCacheFileDuration | The number of minutes that a file name will remain in the download cache. |
EnableFileDetailsComparison | Whether the receive component should consider metadata differences when deciding whether to download a file again. |
ExcludeMask | Instructs the component to exclude some files when downloading. |
FileMaskDelimiter | Specifies a delimiter to use for setting multiple file masks. |
FilePermissions | Specifies the permissions of a file to be set after a successful upload. |
IgnoreFileMaskCasing | Instructs the component to ignore casing of when FileMask is set. |
KeyRenegotiationThreshold | Sets the threshold for the SSH Key Renegotiation. |
ListDirBeforeDelete | Determines if the directory is listed before a resource is deleted. |
ListDirBeforeDownload | Determines if the directory is listed on download. |
LocalEOL | When TransferMode is set, this specifies the line ending for the local system. |
LocalFile | The name of the LocalFile to which the remote file will be saved. |
Logoff | Whether or not to logoff from the server after execution. |
LogSSHPackets | If True, detailed SSH packet logging is performed. |
MaxFileData | Specifies the maximum payload size of an SFTP packet. |
MaxFilesPerPollingInterval | The maximum number of files that will be downloaded from the server during a single poll. |
PreserveFileTime | Preserves the file's timestamps during transfer. |
ProtocolVersion | The highest allowable SFTP version to use. |
RecursiveDownload | When true, all files and folders in the RemotePath are downloaded recursively. |
RecursiveUpload | When true, all files and folders in the folder specified in LocalFile are uploaded recursively. |
RenameMode | The condition under which RenameTo is used. |
RenameTo | A filename to which RemoteFile will be renamed. |
ServerEOL | When TransferMode is set, this specifies the line ending for the remote system. |
SortCriteria | Determines sort order before downloading files. |
SSHAcceptServerHostKeyFingerPrint | Instructs the component to accept the server's host key with this fingerprint. |
SSHEncryptionAlgorithms | A comma-separated list containing all allowable compression algorithms. |
SSHFingerprintHashAlgorithm | The algorithm used to calculate the fingerprint. |
SSHKeyExchangeAlgorithms | Specifies the supported key exchange algorithms. |
SSHMacAlgorithms | Specifies the supported Mac algorithms. |
SSHPublicKeyAlgorithms | Specifies the supported public key algorithms for the server's public key. |
TemporaryDownloadExtension | An extension to be appended during download. |
TemporaryUploadExtension | An extension to be appended during upload. |
TransferMode | The transfer mode (ASCII or Binary). |
UseStrictKeyExchange | Specifies how strict key exchange is supported. |
WaitForServerDisconnect | Causes the component to wait for the server to close the connection. |
AbsoluteTimeout | Determines whether timeouts are inactivity timeouts or absolute timeouts. |
LocalHost | The name of the local host or user-assigned IP interface through which connections are initiated or accepted. |
TcpNoDelay | Whether or not to delay when sending packets. |
UseInternalSecurityAPI | Whether or not to use the system security libraries or an internal implementation. |
AfterConnect Property (SFTP Task)
A set of FTP-style commands to be executed immediately after connecting to the SSHHost .
Data Type
String
Default Value
""
Remarks
AfterConnect is a script that is executed immediately following a successful connection.
Each line in the script is treated as a single command. By default, if the task encounters any errors while executing a command, it will log the error message and will continue to process the script. This behavior can be turned off by inserting "ONERROR FAIL" at any point in the script, which will cause the script to terminate on error but will not interrupt the normal operation of the task. The default behavior can be restored at any point in the script by inserting the line "ONERROR RESUME".
Valid additional scripting commands are listed below:
cd Path | Change the remote directory to the specified path. |
del Filename | Delete the specified file from the remote server. |
mkdir Directory | Create the specified remote directory on the server. |
rn Filename NewFilename | Rename the remote file specified by Filename to the NewFilename. |
move Filename NewFilename | Move the remote file located at Filename to the NewFilename. |
rm Filename | Remove the specified file from the remote server. |
rmdir Directory | Remove the remote directory from the server. |
touch Filename | Create the specified file on the server. |
AfterGet Property (SFTP Task)
A set of FTP-style commands to be executed after the download.
Data Type
String
Default Value
""
Remarks
AfterGet is a script that is executed immediately following each successful download operation.
Each line in the script is treated as a single command. By default, if the task encounters any errors while executing a command, it will log the error message and will continue to process the script. This behavior can be turned off by inserting "ONERROR FAIL" at any point in the script, which will cause the script to terminate on error but will not interrupt the normal operation of the task. The default behavior can be restored at any point in the script by inserting the line "ONERROR RESUME".
Valid additional scripting commands are listed below:
cd Path | Change the remote directory to the specified path. |
del Filename | Delete the specified file from the remote server. |
mkdir Directory | Create the specified remote directory on the server. |
rn Filename NewFilename | Rename the remote file specified by Filename to the NewFilename. |
move Filename NewFilename | Move the remote file located at Filename to the NewFilename. |
rm Filename | Remove the specified file from the remote server. |
rmdir Directory | Remove the remote directory from the server. |
touch Filename | Create the specified file on the server. |
This property is not available in the Sender.
AfterPut Property (SFTP Task)
A set of FTP-style commands to be executed after the upload.
Data Type
String
Default Value
""
Remarks
AfterPut is a script that is executed immediately following each successful upload operation.
Each line in the script is treated as a single command. By default, if the task encounters any errors while executing a command, it will log the error message and will continue to process the script. This behavior can be turned off by inserting "ONERROR FAIL" at any point in the script, which will cause the script to terminate on error but will not interrupt the normal operation of the task. The default behavior can be restored at any point in the script by inserting the line "ONERROR RESUME".
Valid additional scripting commands are listed below:
cd Path | Change the remote directory to the specified path. |
del Filename | Delete the specified file from the remote server. |
mkdir Directory | Create the specified remote directory on the server. |
rn Filename NewFilename | Rename the remote file specified by Filename to the NewFilename. |
move Filename NewFilename | Move the remote file located at Filename to the NewFilename. |
rm Filename | Remove the specified file from the remote server. |
rmdir Directory | Remove the remote directory from the server. |
touch Filename | Create the specified file on the server. |
This property is not available in the Receiver.
Append Property (SFTP Task)
Whether or not the component should append data to the RemoteFile .
Data Type
Boolean
Default Value
false
Remarks
This property controls the task's upload behavior. When set to TRUE, the task will append data to the file specified by RemoteFile rather than creating or overwriting it.
This property is not available in the Receiver.
BeforeGet Property (SFTP Task)
A set of FTP-style commands to be executed before the download.
Data Type
String
Default Value
""
Remarks
BeforeGet is a script that is executed immediately before each download operation.
Each line in the script is treated as a single command. By default, if the task encounters any errors while executing a command, it will log the error message and will continue to process the script. This behavior can be turned off by inserting "ONERROR FAIL" at any point in the script, which will cause the script to terminate on error but will not interrupt the normal operation of the task. The default behavior can be restored at any point in the script by inserting the line "ONERROR RESUME".
Valid additional scripting commands are listed below:
cd Path | Change the remote directory to the specified path. |
del Filename | Delete the specified file from the remote server. |
mkdir Directory | Create the specified remote directory on the server. |
rn Filename NewFilename | Rename the remote file specified by Filename to the NewFilename. |
move Filename NewFilename | Move the remote file located at Filename to the NewFilename. |
rm Filename | Remove the specified file from the remote server. |
rmdir Directory | Remove the remote directory from the server. |
touch Filename | Create the specified file on the server. |
This property is not available in the Sender.
BeforePut Property (SFTP Task)
A set of FTP-style commands to be executed before the upload.
Data Type
String
Default Value
""
Remarks
BeforePut is a script that is executed immediately before each upload operation.
Each line in the script is treated as a single command. By default, if the task encounters any errors while executing a command, it will log the error message and will continue to process the script. This behavior can be turned off by inserting "ONERROR FAIL" at any point in the script, which will cause the script to terminate on error but will not interrupt the normal operation of the task. The default behavior can be restored at any point in the script by inserting the line "ONERROR RESUME".
Valid additional scripting commands are listed below:
cd Path | Change the remote directory to the specified path. |
del Filename | Delete the specified file from the remote server. |
mkdir Directory | Create the specified remote directory on the server. |
rn Filename NewFilename | Rename the remote file specified by Filename to the NewFilename. |
move Filename NewFilename | Move the remote file located at Filename to the NewFilename. |
rm Filename | Remove the specified file from the remote server. |
rmdir Directory | Remove the remote directory from the server. |
touch Filename | Create the specified file on the server. |
This property is not available in the Receiver.
Delete Property (SFTP Task)
Controls if the remote file is deleted after download.
Data Type
Boolean
Default Value
false
Remarks
If this property is set to True, each file is deleted from the server after download.
This property is not available in the Sender.
DirList Property (SFTP Task)
String denoting the name of the variable which contains the last directory listing entries.
Data Type
String
Default Value
"<none>"
Remarks
This property denotes a variable name which contains the collection of directory listings returned from the server when the Operation property has been set to opListDirectory. The collection is made up of entries for each listing in the current directory, specified by the RemotePath property.
The variable is in the form of a datatable. The table's rows represent a directory listing, and the columns represent a different property of the listing. The columns of the datatable are listed below:
(0) FileName | The name of the file being listed. |
(1) FileSize | The size of the file. |
(2) FileTime | The creation date of the file. In Unix systems the date is given in two types of formats: If the date is in the last 12 months the exact time is specified and the year is omitted. Otherwise only the date and the year but not hours or minutes are given. |
(3) IsDir | Denotes whether the listing is a directory or a file. |
(4) Listing | The filename, and extended file information. |
(0) ReceivedFileName | The name of the received file. |
(1) ReceivedFileSize | The size of the file. |
(2) ReceivedFileDate | The creation date of the file. In Unix systems the date is given in two types of formats: If the date is in the last 12 months the exact time is specified and the year is omitted. Otherwise only the date and the year but not hours or minutes are given. |
(3) ReceivedFileSSHUser | The user name used to by the SFTP task when downloading the remote file. |
This property is read-only.
This property is not available in the Sender.
FileMask Property (SFTP Task)
Indicates the type of files to download from the SSH server.
Data Type
String
Default Value
"*.*"
Remarks
This property will limit what kinds of files the task will download from the server. Only files matching the pattern specified in FileMask will be retrieved.
The following special characters are supported for pattern matching:
? | Any single character. |
* | Any characters or no characters (e.g., C*t matches Cat, Cot, Coast, Ct). |
[,-] | A range of characters (e.g., [a-z], [a], [0-9], [0-9,a-d,f,r-z]). |
\ | The slash is ignored and exact matching is performed on the next character. |
If these characters need to be used as a literal in a pattern, then they must be escaped by surrounding them with brackets []. Note: "]" and "-" do not need to be escaped. See below for the escape sequences:
Character | Escape Sequence |
? | [?] |
* | [*] |
[ | [[] |
\ | [\] |
For example, to match the value [Something].txt, specify the pattern [[]Something].txt.
This property is not available in the Sender.
Firewall Property (SFTP Task)
A set of properties related to firewall access.
Data Type
Remarks
This is a Firewall type property which contains fields describing the firewall through which the task will attempt to connect.
LocalDirectory Property (SFTP Task)
The directory on the local machine where files are downloaded.
Data Type
String
Default Value
""
Remarks
This property tells the task where to write all downloaded files to on the local machine. The downloaded files will be written to the remote file name in the specified directory.
This property is not available in the Sender.
LocalFile Property (SFTP Task)
The path to a local file for upload.
Data Type
String
Default Value
""
Remarks
The LocalFile property is the name of the file or a file mask on the local host to be uploaded to the SSH server.
This property is not available in the Receiver.
LogFile Property (SFTP Task)
The file to write logging information to at runtime.
Data Type
String
Default Value
""
Remarks
To write logging information to a file instead of using the task's logging API, set this property to a valid file on disk.
When set, any logging information is appended to the specified file and not written to the task's logging API.
LogMode Property (SFTP Task)
What information gets logged during component execution.
Data Type
Enumeration
Possible Values
Verbose (0)
Info (1)
Warning (2)
Error (3)
Fatal (4)
Default Value
3
Remarks
This property controls what information the task logs. The possible values have the following affect on the task's behavior:
Verbose | The task will report all information regarding the transport. |
Info | The task will report all major operations, as well as all warnings and errors. |
Warning | The task will report any conditions that could result in unpredictable behavior as well as errors. |
Error | The task will report all errors that prevent normal operations from completing. |
Fatal | The task will report only serious errors that cause the task to completely stop functioning. |
Operation Property (SFTP Task)
The operation which will be executed by the FTP task.
Data Type
Enumeration
Possible Values
Receive Files (0)
List Directory (1)
Delete Files (2)
Default Value
0
Remarks
There are three different operations that the FTP Receive task may perform. It may download files, ask the server to return a directory listing, or delete files.
The default for this property is to receive files.
This property is not available in the Sender.
Other Property (SFTP Task)
Defines a set of configuration settings to be used by the component.
Data Type
String
Default Value
""
Remarks
The task accepts one or more configuration settings. Configuration settings are similar in functionality to properties, but they are rarely used. In order to avoid "polluting" the property namespace of the task, access to these internal properties is provided through the Other property.
The Other property may be set to one or more configuration settings (name/value pairs). Set one setting per line.
For example:
configname1=value1
configname2=value2
Overwrite Property (SFTP Task)
Whether or not the component should overwrite files during transfer.
Data Type
Boolean
Default Value
false
Remarks
This property is a value indicating whether or not the task should overwrite files on the server or local system if they already exist. If Overwrite is false, an error will be thrown whenever RemoteFile exists before an upload operation, or the file exists in LocalDirectory before a download operation.
PersistentConnection Property (SFTP Task)
Instructs the component whether to keep the connection to the server open.
Data Type
Boolean
Default Value
false
Remarks
If set to true, the task will first attempt to use an existing connection. If no such connection exists, it will create a new connection. When the task completes, it will persist the connection so that the task will reuse it during the next polling interval. Setting this property to true can improve performance if you are polling very frequently.
Set the Logoff configuration to tell the task to logoff from the persisted connection after completion.
RemoteFile Property (SFTP Task)
The name of the destination file on the SSH server for uploading.
Data Type
String
Default Value
"%SourceFileName%"
Remarks
The RemoteFile is either an absolute file path, or a relative path based on RemotePath.
This property is not available in the Receiver.
RemotePath Property (SFTP Task)
The current path on the SSH server.
Data Type
String
Default Value
""
Remarks
The RemotePath can be used to set the working directory by setting it to either an absolute directory path or a path relative to the initial remote directory when the task connects to the SSH server.
RemoteTempPath Property (SFTP Task)
A temporary directory on the server to store files before moving them to RemotePath .
Data Type
String
Default Value
""
Remarks
If a value is specified, the task will directly upload the file to RemoteTempPath. Once the file transfer is complete, the task will move the file to the RemotePath.
This property is not available in the Receiver.
RuntimeLicense Property (SFTP Task)
Specifies the component runtime license key.
Data Type
String
Default Value
""
Remarks
You can use the RuntimeLicense property to set the runtime key for the task license.
SSHAcceptServerHostKey Property (SFTP Task)
Instructs the component to accept the server host key that matches the supplied key.
Data Type
Remarks
If the host key that will be used by the server is known in advance, this property may be set to accept the expected key. If you are using the fingerprint, you may supply it to the SSHAcceptServerHostKeyFingerPrint setting by HEX encoding the values in the form "0a:1b:2c:3d". If this property is not set the server will not be authenticated, and the connection will be refused by the client.
Note: You may also set SSHAcceptServerHostKeyAcceptAny to True without opening the certificate selection dialog to force the adapter to unilaterally authenticate any server during the security handshake. It is strongly recommended that you use this only for testing purposes.
SSHAcceptServerHostKeyAcceptAny Property (SFTP Task)
Tells the component to accept any server certificate.
Data Type
Boolean
Default Value
false
Remarks
When set to true, the task will unilaterally authenticate any server during the security handshake. It is strongly recommended that you use this only for testing purposes.
SSHAuthMode Property (SFTP Task)
The type of authentication used by the component.
Data Type
Enumeration
Possible Values
None (0)
Multi Factor (1)
Password (2)
Public Key (3)
Keyboard Interactive (4)
GSSAPIWith Mic (5)
Default Value
2
Remarks
SSHAuthMode controls how the task attempts to authenticate when connecting to the SSHHost. The following authentication methods are available:
None | The task will attempt anonymous authentication. |
Multi-Factor | The task will attempt as many authentication steps as the server requires using whatever credentials it has available. |
Password | The task will send the SSHPassword to the server. |
Public Key | The task will send the SSHCert to the server; |
Keyboard-Interactive | The task will perform SSH keyboard-interactive authentication, responding automatically to the server's authentication prompts. It will supply the value of SSHPassword as the response to the "password" prompt. Note: this method is not truly keyboard-interactive, and the task may not recognize all prompts supplied by the server. It should be used only when the SSHHost cannot be configured to authenticate the SSHUser via more easily automated methods such as Password or Public Key. |
GSSAPIWithMic | This allows the task to attempt Kerberos authentication using the GSSAPI-WITH-MIC scheme. The client will try Kerberos authentication using the value of SSHUser (single sign-on), or if SSHPassword is specified as well, it will try Kerberos authentication with alternate credentials. |
SSHCert Property (SFTP Task)
The certificate to use for client authentication during the SSH handshake.
Data Type
Remarks
This property is used to assign a specific certificate for SSH client authentication.
This field is used to set a Private Key Certificate.
Private key certificates may be loaded from the registry, from files in PKCS#12 format, or from a PEM file format. If you click on the ellipses, a certificate selection dialog will open. To select a private key from the system registry, select the System Store tab or the User Store tab, and highlight the appropriate registry store. The list of certificates which have private keys will be shown below.
To select a private key certificate from a file in PKCS#12 format, select the PFX Store tab. The browse button can be used to examine the file system for PKCS#12 (.pfx or .p12) certificates. If you wish to examine the certificate, provide the password in the field provided and click on the Open button to examine the file store for certificates present. To load a certificate from PEM files, select the PEM tab. Like the PFX file selection, you can specify the password and click the Open button to examine the certificates in the PEM store, or you may paste any PEM data stored in memory.
Regardless of how you selected the certificate, once you hit the OK button, the task will attempt to verify that certificate selection. If successful, the subject of the certificate will be displayed in the property field. If the task was not able to verify the selection, a dialog box will appear instead detailing the verification error.
SSHCompressionAlgorithms Property (SFTP Task)
A comma-separated list of compression algorithms allowed for this connection.
Data Type
String
Default Value
"none"
Remarks
This list is used for both directions: client to server and server to client. When negotiating algorithms, each side sends a list of all algorithms it supports or allows. The algorithm chosen for each direction is the first algorithm to appear in the sender's list that the receiver supports, so it is important to list multiple algorithms in preferential order. If no algorithm can be agreed upon, the task will raise an error and the connection will be aborted.
SSHCompressionAlgorithms must be set to a comma-separated list containing at least one of the following values:
zlib | Zlib compression is allowed for this connection. |
none | No compression is allowed for this connection. |
SSHHost Property (SFTP Task)
The address of the SSH host.
Data Type
String
Default Value
""
Remarks
The SSHHost property specifies the IP address (IP number in dotted internet format) or Domain Name of the remote host. It is set before a connection is attempted and cannot be changed once a connection is established.
If the SSHHost property is set to a Domain Name, a DNS request is initiated, and upon successful termination of the request, the SSHHost property is set to the corresponding address. If the search is not successful, an error is logged.
SSHPassword Property (SFTP Task)
The password for SSH password-based authentication.
Data Type
Password
Default Value
""
Remarks
SSHPassword specifies the password which is used to authenticate the client to the SSH server.
SSHPort Property (SFTP Task)
The port on the SSH server where the SSH service is running; by default, 22.
Data Type
Integer
Default Value
22
Remarks
The SSHPort specifies a service port on the SSH host to connect to.
SSHUser Property (SFTP Task)
The username for SSH authentication.
Data Type
String
Default Value
""
Remarks
SSHUser specifies the username which is used to authenticate the client to the SSH server. This property is required.
Timeout Property (SFTP Task)
A timeout for the component.
Data Type
Integer
Default Value
60
Remarks
If the Timeout property is set to 0, all operations will run uninterrupted until successful completion, or an error condition is encountered.
If Timeout is set to a positive value, the task will wait for the operation to complete before returning control.
If Timeout expires, and the operation is not yet complete, the task fails with an error.
Please note that by default, all timeouts are inactivity timeouts, i.e. the timeout period is extended by Timeout seconds when data is successfully sent or received.
Optionally, the behavior of the task may be changed to absolute timeouts, i.e. the task will wait for a maximum of Timeout seconds since the beginning of the operation, without extending the timeout period during communications.
This behavior is controlled by the AbsoluteTimeout configuration setting.
The default value for the Timeout property is 60 (seconds).
Certificate Type
The digital certificate being used.
Remarks
This type describes the current digital certificate. The certificate may be a public or private key. The fields are used to identify or select certificates.
Fields
The name of the certificate store for the client certificate.
The StoreType field specifies the type of the certificate store specified by Store. If the store is password protected, specify the password in StorePassword.
Store is used in conjunction with the Subject field in order to specify client certificates. If Store has a value, and Subject is set, a search for a certificate is initiated. Please refer to the Subject field for details.
Designations of certificate stores are platform-dependent.
The following are designations of the most common User and Machine certificate stores in Windows:
MY | A certificate store holding personal certificates with their associated private keys. |
CA | Certifying authority certificates. |
ROOT | Root certificates. |
SPC | Software publisher certificates. |
In Java, the certificate store normally is a file containing certificates and optional private keys.
When the certificate store type is PFXFile, this property must be set to the name of the file. When the type is PFXBlob, the property must be set to the binary contents of a PFX file (i.e. PKCS12 certificate store).
If the provider is OpenSSL, the certificate store is a file containing a certificate and a private key. This property must be set to the name of the file.
If the certificate store is of a type that requires a password, this property is used to specify that password in order to open the certificate store.
The type of certificate store for this certificate.
The task supports both public and private keys in a variety of formats. When the cstAuto value is used, the task will automatically determine the type. This field can take one of the following values:
0 (cstUser - default) | For Windows, this specifies that the certificate store is a certificate store owned by the current user.
Note: This store type is not available in Java. |
1 (cstMachine) | For Windows, this specifies that the certificate store is a machine store.
Note: This store type is not available in Java. |
2 (cstPFXFile) | The certificate store is the name of a PFX (PKCS#12) file containing certificates. |
3 (cstPFXBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in PFX (PKCS#12) format. |
4 (cstJKSFile) | The certificate store is the name of a Java Key Store (JKS) file containing certificates.
Note: This store type is only available in Java. |
5 (cstJKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in Java Key Store (JKS) format.
Note: This store type is only available in Java. |
6 (cstPEMKeyFile) | The certificate store is the name of a PEM-encoded file that contains a private key and an optional certificate. |
7 (cstPEMKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a private key and an optional certificate. |
8 (cstPublicKeyFile) | The certificate store is the name of a file that contains a PEM- or DER-encoded public key certificate. |
9 (cstPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains a PEM- or DER-encoded public key certificate. |
10 (cstSSHPublicKeyBlob) | The certificate store is a string (binary or Base64-encoded) that contains an SSH-style public key. |
11 (cstP7BFile) | The certificate store is the name of a PKCS#7 file containing certificates. |
12 (cstP7BBlob) | The certificate store is a string (binary) representing a certificate store in PKCS#7 format. |
13 (cstSSHPublicKeyFile) | The certificate store is the name of a file that contains an SSH-style public key. |
14 (cstPPKFile) | The certificate store is the name of a file that contains a PPK (PuTTY Private Key). |
15 (cstPPKBlob) | The certificate store is a string (binary) that contains a PPK (PuTTY Private Key). |
16 (cstXMLFile) | The certificate store is the name of a file that contains a certificate in XML format. |
17 (cstXMLBlob) | The certificate store is a string that contains a certificate in XML format. |
18 (cstJWKFile) | The certificate store is the name of a file that contains a JWK (JSON Web Key). |
19 (cstJWKBlob) | The certificate store is a string that contains a JWK (JSON Web Key). |
21 (cstBCFKSFile) | The certificate store is the name of a file that contains a BCFKS (Bouncy Castle FIPS Key Store).
Note: This store type is only available in Java and .NET. |
22 (cstBCFKSBlob) | The certificate store is a string (binary or Base64-encoded) representing a certificate store in BCFKS (Bouncy Castle FIPS Key Store) format.
Note: This store type is only available in Java and .NET. |
23 (cstPKCS11) | The certificate is present on a physical security key accessible via a PKCS#11 interface.
To use a security key, the necessary data must first be collected using the CERTMGR task. The ListStoreCertificates method may be called after setting CertStoreType to cstPKCS11, CertStorePassword to the PIN, and CertStore to the full path of the PKCS#11 DLL. The certificate information returned in the CertList event's CertEncoded parameter may be saved for later use. When using a certificate, pass the previously saved security key information as the Store and set StorePassword to the PIN. Code Example. SSH Authentication with Security Key:
|
99 (cstAuto) | The store type is automatically detected from the input data. This setting may be used with both public and private keys and can detect any of the supported formats automatically. |
The subject of the certificate used for client authentication.
When this property is set, a search is performed in the current certificate store certificate with matching subject.
If an exact match is not found, the store is searched for subjects containing the value of the property.
When setting the property to a partial subject, CN= should be omitted. For example, the following code would find the certificate with subject CN=Test Certificate, OU=People, C=US
Example (Searching with partial subject)
Control.CertSubject = "Test"
If a match is not found, the property is set to an empty string, and no certificate is selected.
The special value "*" picks a random certificate in the certificate store.
If a matching certificate is found, Subject is set to the full subject of the matching certificate.
The thumbprint of the certificate.
This field is used to specify the thumbprint of the certificate. When there are multiple certificates in the store that have the same subject, the thumbprint will be used to distinguish between them.
Firewall Type
The firewall the component will connect through.
Remarks
When connecting through a firewall, this type is used to specify different properties of the firewall such as the firewall Host and the FirewallType.
Fields
Tells the task whether or not to automatically detect and use firewall system settings, if available.
Determines the type of firewall to connect through. The applicable values are the following:
Name or IP address of firewall (optional). If a Host is given, requested connections will be authenticated through the specified firewall when connecting.
If the Host field is set to a Domain Name, a DNS request is initiated. Upon successful termination of the request, the Host field is set to the corresponding address. If the search is not successful, an error is returned.
A password if authentication is to be used when connecting through the firewall. If Host is specified, the User and Password fields are used to connect and authenticate to the given firewall. If the authentication fails, a trappable error is fired.
The TCP port for the firewall Host. See the description of the Host field for details.
Note that the Port is set automatically when FirewallType is set to a valid value. See the description of the FirewallType field for details.
A user name if authentication is to be used connecting through a firewall. If the Host is specified, the User and Password fields are used to connect and authenticate to the given Firewall. If the authentication fails, a trappable error is fired.
Config Settings (SFTP Task)
The task accepts one or more of the following configuration settings. Configuration settings are similar in functionality to properties, but they are rarely used. In order to avoid "polluting" the property namespace of the task, access to these internal properties is provided through the Other property.SFTP Config Settings
The default value is 0, meaning that files will never be removed.
This setting is only applicable if DownloadCacheFile is set.
If this is set to False, the receive task will not download a file again if the cache contains any information about it (that is, if it has been downloaded before).
If this is set to True, the receive task will check the metadata of the remote file against its cached metadata, and will download the file again if any of the metadata differs.
FilePermissions=0777
Note: When using the SCP task this must be a 4 digit value. The SFTP task will accept a 3 digit value.
Example. Setting the Threshold to 500 MB:
SSHComponent.Config("KeyRenegotiationThreshold=524288000")
When uploading or downloading this value will be compared to ServerEOL. If ServerEOL and LocalEOL are different, the line endings in the file being transferred will be converted to the line endings used by the destination. Line endings will be converted to the value in LocalEOL when downloading. Line endings will be converted to the value in ServerEOL when uploading. If ServerEOL and LocalEOL are the same, no conversion takes place.
The value supplied to this setting should contain a C# .NET style character sequence:
TransferMode=1
LocalEOL=\r\ n
Conversion will only happen when TransferMode is set to 1 (ASCII) and ServerEOL and LocalEOL are different.
Note that if multiple files are downloaded from the server, the task will attempt to save all files using the value specified. For this reason, it is recommended that this setting be used only in cases where only one file is being downloaded from the server.
The default for this configuration setting is false.
Most servers that use smaller values will use a maximum SSH packet size of 16KB (16384). In order to most efficiently communicate with such servers, MaxFileData size should be set to 14745.
Note that to avoid downloading the same subset of files each poll, either DownloadCacheFile or DeleteMode should also be used.
1 (OnSuccess - default) | The file is renamed using the value in RenameTo only after the message is successfully submitted to BizTalk. |
2 (OnFailure) | The file is renamed using the value in RenameTo only after the message submission to BizTalk fails. |
3 (Always) | The file is renamed using the value in RenameTo regardless of the message submission result. |
RenameTo=%SourceFileName%.done
Macros such as %SourceFileName% are supported as in the given example. A full list of supported macros can be found at the bottom of this section.
When uploading or downloading this value will be compared to LocalEOL. If ServerEOL and LocalEOL are different, the line endings in the file being transferred will be converted to the line endings used by the destination. Line endings will be converted to the value in LocalEOL when downloading. Line endings will be converted to the value in ServerEOL when uploading. If ServerEOL and LocalEOL are the same, no conversion takes place.
The value supplied to this setting should contain a C# .NET style character sequence:
TransferMode=1
ServerEOL=\r\ n
Conversion will only happen when TransferMode is set to 1 (ASCII) and ServerEOL and LocalEOL are different.
- 0 - Disabled
- 1 - Name, ascending
- 2 - Name, descending
- 3 - Date, ascending
- 4 - Date, descending
SSHAcceptServerHostKeyFingerprint=0a:1b:2c:3d
At least one supported algorithm must appear in this list. The following encryption algorithms are supported by the component:
aes256-cbc | 256-bit AES encryption in CBC mode |
aes192-cbc | 192-bit AES encryption in CBC mode |
aes128-cbc | 128-bit AES encryption in CBC mode |
3des-cbc | 192-bit (3-key) triple DES encryption in CBC mode |
aes256-ctr | 256-bit AES encryption in CTR mode |
aes192-ctr | 192-bit AES encryption in CTR mode |
aes128-ctr | 128-bit AES encryption in CTR mode |
3des-ctr | 192-bit (3-key) triple DES encryption in CTR mode |
cast128-cbc | CAST-128 encryption |
blowfish-cbc | Blowfish encryption |
arcfour | ARC4 encryption |
arcfour128 | 128-bit ARC4 encryption |
arcfour256 | 256-bit ARC4 encryption |
aes256-gcm@openssh.com | 256-bit AES encryption in GCM mode. |
aes128-gcm@openssh.com | 128-bit AES encryption in GCM mode. |
The default value is "aes256-ctr,aes192-ctr,aes128-ctr,aes256-cbc,aes192-cbc,aes128-cbc,3des-ctr,3des-cbc,blowfish-cbc,arcfour256,arcfour128,arcfour,cast128-cbc,aes256-gcm@openssh.com,aes128-gcm@openssh.com".
- MD5 (default)
- SHA1
- SHA256
- curve25519-sha256
- curve25519-sha256@libssh.org
- diffie-hellman-group1-sha1
- diffie-hellman-group14-sha1
- diffie-hellman-group14-sha256
- diffie-hellman-group16-sha512
- diffie-hellman-group18-sha512
- diffie-hellman-group-exchange-sha256
- diffie-hellman-group-exchange-sha1
- ecdh-sha2-nistp256
- ecdh-sha2-nistp384
- ecdh-sha2-nistp521
- gss-group14-sha256-toWM5Slw5Ew8Mqkay+al2g==
- gss-group16-sha512-toWM5Slw5Ew8Mqkay+al2g==
- gss-nistp256-sha256-toWM5Slw5Ew8Mqkay+al2g==
- gss-curve25519-sha256-toWM5Slw5Ew8Mqkay+al2g==
- gss-group14-sha1-toWM5Slw5Ew8Mqkay+al2g==
- gss-gex-sha1-toWM5Slw5Ew8Mqkay+al2g==
- hmac-sha1
- hmac-md5
- hmac-sha1-96
- hmac-md5-96
- hmac-sha2-256
- hmac-sha2-256-96
- hmac-sha2-512
- hmac-sha2-512-96
- hmac-ripemd160
- hmac-ripemd160-96
- hmac-sha2-256-etm@openssh.com
- hmac-sha2-512-etm@openssh.com
- hmac-sha2-256-96-etm@openssh.com
- hmac-sha2-512-96-etm@openssh.com
- umac-64@openssh.com
- umac-64-etm@openssh.com
- umac-128@openssh.com
- umac-128-etm@openssh.com
This setting specifies a list of signature algorithms that may be used when authenticating to the server using public key authentication. This applies only when public key authentication is performed by the client.
The setting should be a comma-separated list of algorithms. At runtime, the task will evaluate the specified algorithms, and if the algorithm is applicable to the certificate specified in SSHCert, it will be used. If the algorithm is not applicable, the task will evaluate the next algorithm. Possible values are as follows:
- ssh-rsa
- rsa-sha2-256
- rsa-sha2-512
- ssh-dss
- ecdsa-sha2-nistp256
- ecdsa-sha2-nistp384
- ecdsa-sha2-nistp521
- ssh-ed25519
- x509v3-sign-rsa
- x509v3-sign-dss
The default value in Windows is ssh-rsa,rsa-sha2-256,rsa-sha2-512,ssh-dss,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,ssh-ed25519.
rsa-sha2-256 and rsa-sha2-512 notes
The task will query the server for supported algorithms when connecting. If the server indicates support for rsa-sha2-256 or rsa-sha2-512 and the algorithm is present in the list defined by this setting (as in the default value), that algorithm will be used instead of ssh-rsa even when ssh-rsa appears first in the list.
For the rsa-sha2-256 and rsa-sha2-512 algorithms to be automatically preferred, the server must support the ext-info-c mechanism. In practice, older servers do not support this, and in that case, ssh-rsa will be used because it appears first in the list. Newer servers do support this mechanism, and in that case, rsa-sha2-256 or rsa-sha2-512 will be used even though it appears after ssh-rsa.
This behavior has been carefully designed to provide maximum compatibility while automatically using more secure algorithms when connecting to servers that support them.
When this value is set to 1 (ASCII) the task will use the values specified in LocalEOL and ServerEOL to convert line endings as appropriate.
Note: When this value is set to 1 (ASCII) and ProtocolVersion is set to 4 or higher the task will automatically determine the value for ServerEOL if the server supports the "newline" protocol extension.
Because both client and server must implement strict key exchange to effectively mitigate the Terrapin attack, the task provides options to further control the behavior in different scenarios. Possible values for this setting are as follows:
0 | Disabled. Strict key exchange is not supported in the task. |
1 (default) | Enabled, but not enforced. This setting enables strict key exchange, but if the remote host does not support strict key exchange the connection is still allowed to continue. |
2 | Enabled, but will reject affected algorithms if the remote host does not support strict key exchange. If the remote host supports strict key exchange, all algorithms may be used. If the remote host does not support strict key exchange, the connection will continue only if the selected encryption and message authentication code (MAC) algorithms are not affected by the Terrapin attack. |
3 | Required. If the remote host does not support strict key exchange, the connection will fail. |
General Config Settings
In multihomed hosts (machines with more than one IP interface) setting LocalHost to the value of an interface will make the task initiate connections (or accept in the case of server tasks) only through that interface.
If the task is connected, the LocalHost configuration shows the IP address of the interface through which the connection is made in internet dotted format (aaa.bbb.ccc.ddd). In most cases, this is the address of the local host, except for multihomed hosts (machines with more than one IP interface).
By default, this configuration setting is set to False.
Setting this configuration setting to True tells the task to use the internal implementation instead of using the system security libraries.
On Windows, this setting is set to False by default. On Linux/macOS, this setting is set to True by default.
If using the .NET Standard Library, this setting will be True on all platforms. The .NET Standard library does not support using the system security libraries.
Note: This setting is static. The value set is applicable to all tasks used in the application.
When this value is set, the product's system dynamic link library (DLL) is no longer required as a reference, as all unmanaged code is stored in that file.