FTP Task
The FTP Component adds SSL-enabled FTP send and receive capabilities to your SSIS Package.
Remarks
The FTP Task adds a complete FTP client to your SSIS Package and enables it with plaintext or SSL-secured file download and upload capability.
FTP Receive Task
A single property must be set: FTPServer. You may also set an FTPPort if the server is not set to the default protocol port. If your FTP server requires authentication, you should set the User, Password and/or Account properties. If you wish to enable SSL, you can turn it on by setting an appropriate SSLCert and SSLStartMode as well as supplying an SSLAcceptServerCert.
The task will connect to the FTP server 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. If you wish to do any other PRE- or POST-GET operation, you can specify them as scripts through the BeforeGet and AfterGet properties, respectively.
FTP Send Task
Two properties must be set: FTPServer and a RemoteFile. If your server does not operate on the default FTP port, you will need to specify the correct port via FTPPort. For servers that do not allow anonymous uploads, you may also need to set User, Password, and/or Account. To enable SSL, you should select a client SSLCert and a SSLAcceptServerCert as well as an SSLStartMode.
The task will connect to the FTP server whenever it has a message to send. The task will attempt to upload to the specified RemotePath. In order to prevent parallel processing by another application before your upload is complete, you may need to set a temporary extension via TemporaryUploadExtension. If Overwrite is set to True, the task will delete or overwrite remote files as necessary to complete the operation.
If you wish to do any other PRE- or POST-PUT operation, you can specify them as scripts through the BeforePut and AfterPut properties, respectively.
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 commands to be executed immediately after connecting to the FTPServer . |
AfterGet | A set of FTP commands to be executed after the GET. |
BeforeGet | A set of FTP commands to be executed before the GET. |
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 FTP server. |
Firewall | A set of properties related to firewall access. |
FTPPort | The port for the FTP service (default is 21). |
FTPServer | The domain name or IP address of the FTP server. |
LocalDirectory | The directory on the local machine to write downloaded files to. |
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. |
Passive | Controls whether to direct the server into passive mode. Recommended if behind a firewall. |
Password | The password for login. |
PersistentConnection | Instructs the component whether to keep the connection to the server open. |
RemotePath | The current path in the FTP server. |
RuntimeLicense | Specifies the component runtime license key. |
SSLAcceptServerCert | Instructs the component to unconditionally accept the server certificate that matches the supplied certificate. |
SSLAcceptServerCertAcceptAny | Tells the component to accept any server certificate. |
SSLCert | The certificate to use for client authentication during the SSL handshake. |
SSLStartMode | Determines how the component starts the SSL negotiation. |
Timeout | A timeout for the component. |
TransferMode | The transfer mode (ASCII or Binary). If the value is 0 (default), the initial server mode will be used. |
User | The user id for login. |
UseSimpleDirList | Instructs the component to issue the NLST command instead of LIST. |
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 commands to be executed immediately after connecting to the FTPServer . |
AfterPut | A set of FTP commands to be executed after the PUT. |
Append | Whether or not the component should append data to the RemoteFile . |
BeforePut | A set of FTP commands to be executed before the PUT. |
Firewall | A set of properties related to firewall access. |
FTPPort | The port for the FTP service (default is 21). |
FTPServer | The domain name or IP address of the FTP server. |
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. |
Passive | Controls whether to direct the server into passive mode. Recommended if behind a firewall. |
Password | The password for login. |
PersistentConnection | Instructs the component whether to keep the connection to the server open. |
RemoteFile | The name of the destination file on the FTP server for uploading. |
RemotePath | The current path in the FTP server. |
RemoteTempPath | A temporary directory on the server to store files before moving them to RemotePath . |
RuntimeLicense | Specifies the component runtime license key. |
SSLAcceptServerCert | Instructs the component to unconditionally accept the server certificate that matches the supplied certificate. |
SSLAcceptServerCertAcceptAny | Tells the component to accept any server certificate. |
SSLCert | The certificate to use for client authentication during the SSL handshake. |
SSLStartMode | Determines how the component starts the SSL negotiation. |
Timeout | A timeout for the component. |
TransferMode | The transfer mode (ASCII or Binary). If the value is 0 (default), the initial server mode will be used. |
User | The user id for login. |
UseSimpleDirList | Instructs the component to issue the NLST command instead of LIST. |
Config Settings
The following is a list of config settings for the task with short descriptions. Click on the links for further details.
Account | The user account to login with. |
AutoSelectDataIP | Automatically select the data connection IP. |
CheckFileExists | Whether to check if the remote file exists before uploading. |
DirEntryPattern | Allows the use of regular expressions to parse non-standard directory entry formats. |
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. |
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. |
MaxFilesPerPollingInterval | The maximum number of files that will be downloaded from the server during a single poll. |
ModeZCompressionLevel | Used to specify the level of compression used. |
PortRange | Allows the specification of a port range the component listens to. |
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. |
ReusePISSLSessionInDI | Whether the PI SSL session will be reused for the DI connection. |
ReuseSSLSessionInDI | Whether the SSL session will be reused for the DI connection. |
TemporaryDownloadExtension | An extension to be appended during download. |
TemporaryUploadExtension | An extension to be appended during upload. |
UseClearCommandChannel | Allows for the Clear Command Channel (CCC) command. |
UseClearDataChannel | Allows for the PROT C command. |
UseEPSV | Allows extended passive mode. |
UseFSwitch | Specifies whether or not the -F parameter is used when listing directory contents. |
UseMLSD | Uses listings for machine processing. |
UseModeZ | Allows compression to be used when transferring data. |
UseProtWhenImplicit | Sends PROT P to the server. |
UseRemoteHostAddressForPassive | Instructs the component to use the FTPServer in passive mode. |
ReuseSSLSession | Determines if the SSL session is reused. |
SSLCipherStrength | The minimum cipher strength used for bulk encryption. |
SSLEnabledCipherSuites | The cipher suite to be used in an SSL negotiation. |
SSLEnabledProtocols | Used to enable/disable the supported security protocols. |
SSLIncludeCertChain | Whether the entire certificate chain is included in the SSLServerAuthentication event. |
SSLSecurityFlags | Flags that control certificate verification. |
TLS12SignatureAlgorithms | Defines the allowed TLS 1.2 signature algorithms when UseInternalSecurityAPI is True. |
TLS12SupportedGroups | The supported groups for ECC. |
TLS13KeyShareGroups | The groups for which to pregenerate key shares. |
TLS13SignatureAlgorithms | The allowed certificate signature algorithms. |
TLS13SupportedGroups | The supported groups for (EC)DHE key exchange. |
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 (FTP Task)
A set of FTP commands to be executed immediately after connecting to the FTPServer .
Data Type
String
Default Value
""
Remarks
AfterConnect is a script that is executed immediately following a successful connection.
The script may contain any number of standard FTP commands.
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 (FTP Task)
A set of FTP commands to be executed after the GET.
Data Type
String
Default Value
""
Remarks
AfterGet is a script that is executed immediately following each successful FTP GET operation.
The script may contain any number of standard FTP commands.
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 (FTP Task)
A set of FTP commands to be executed after the PUT.
Data Type
String
Default Value
""
Remarks
AfterPut is a script that is executed immediately following each successful FTP PUT operation.
The script may contain any number of standard FTP commands.
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 (FTP 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 (FTP Task)
A set of FTP commands to be executed before the GET.
Data Type
String
Default Value
""
Remarks
BeforeGet is a script that is executed immediately before each successful FTP GET operation.
The script may contain any number of standard FTP commands.
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 (FTP Task)
A set of FTP commands to be executed before the PUT.
Data Type
String
Default Value
""
Remarks
BeforePut is a script that is executed immediately before each successful FTP PUT operation.
The script may contain any number of standard FTP commands.
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 (FTP 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 (FTP 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) ReceivedFileUser | The user name used to by the FTP task when downloading the remote file. |
This property is read-only.
This property is not available in the Sender.
FileMask Property (FTP Task)
Indicates the type of files to download from the FTP server.
Data Type
String
Default Value
"*.*"
Remarks
As long as the server supports file masks, 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 (FTP 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.
FTPPort Property (FTP Task)
The port for the FTP service (default is 21).
Data Type
Integer
Default Value
21
Remarks
A valid port number (a value between 1 and 65535) is required for the connection to take place.
FTPServer Property (FTP Task)
The domain name or IP address of the FTP server.
Data Type
String
Default Value
""
Remarks
The FTPServer property specifies the IP address (IP number in dotted internet format) or Domain Name of the FTP server.
If the FTPServer property is set to a Domain Name, a DNS request is initiated and upon successful termination of the request, the FTPServer property is set to the corresponding address. If the search is not successful, an error is returned.
LocalDirectory Property (FTP Task)
The directory on the local machine to write downloaded files to.
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 (FTP 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 FTP server. For instance "C:\files\*.txt".
This property is not available in the Receiver.
LogFile Property (FTP 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 (FTP 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 (FTP 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
This property specifies the operation to be performed. Possible values are:
- opReceiveFiles (default)
- opListDirectory
- opDeleteFiles
When set to opListDirectory DirList defines the package variable which will be populated with the results.
This property is not available in the Sender.
Other Property (FTP 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 (FTP 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.
Passive Property (FTP Task)
Controls whether to direct the server into passive mode. Recommended if behind a firewall.
Data Type
Boolean
Default Value
true
Remarks
When false, FTP communications take place in Active mode. In an Active mode connection, data connections are established from server to client on an IP address and port specified by the client in a PORT command to the server.
Many firewalls will not allow the FTP server to open a connection from outside to the higher ports where the FTP client task expects them. By default, Passive is set to TRUE, and the task will request that FTP communications take place in Passive mode. In Passive mode, the task will use the PASV instead of the PORT command and data connections will be established from the client to the server.
Password Property (FTP Task)
The password for login.
Data Type
Password
Default Value
""
Remarks
This property must be set before the task connects to the FTP server.
PersistentConnection Property (FTP 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 (FTP Task)
The name of the destination file on the FTP 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 (FTP Task)
The current path in the FTP 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 FTP server.
RemoteTempPath Property (FTP 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 (FTP 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.
SSLAcceptServerCert Property (FTP Task)
Instructs the component to unconditionally accept the server certificate that matches the supplied certificate.
Data Type
Remarks
If it finds any issues with the certificate presented by the server, the task will normally terminate the connection with an error. You may override this behavior by supplying a value for SSLAcceptServerCert. If the certificate supplied in SSLAcceptServerCert is the same as the certificate presented by the server, then the server certificate is accepted unconditionally, and the connection will continue normally.
This property is used to set a Public Key Certificate.
Ordinarily, the system will attempt to locate the public key in trusted certificate stores in the system registry. If a match is found, the certificate is trusted, and the process proceeds without error. If the certificate is not trusted, the task will report an error.
You may explicitly set a public key, either to accept a key that is not installed on the system, or to ensure that a specific key is presented. Public key certificates may be loaded from the machine registry or from file. If you click on the ellipses, a certificate selection dialog will open. To select a public key from the system registry, select the System Store tab or the User Store tab, and highlight the appropriate registry store. The list of available certificates will be shown below.
Alternatively, you may specify a public key on file. Select the PEM or Certificate File tabs to load a public key from file. You can use the browse button to examine the file system for the certificate that you wish to use. Public keys typically are stored in .CER, .DER, or .PEM files, but other formats may be used. You can click on the Open button to examine the contents of the certificate. Or, if you have a certificate stored in memory, you can write the contents of the certificate into the text box provided. Note that if you are loading a certificate from memory, the certificate must be Base-64 encoded, or the string representation of the certificate may become corrupted and uninterpretable.
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.
Note: You may also set SSLAcceptServerCertAcceptAny to True without opening the certificate selection dialog to force the task to unilaterally authenticate any server during the security handshake. It is strongly recommended that you use this only for testing purposes.
SSLAcceptServerCertAcceptAny Property (FTP 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.
SSLCert Property (FTP Task)
The certificate to use for client authentication during the SSL handshake.
Data Type
Remarks
This property is used to assign a specific certificate for SSL 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.
SSLStartMode Property (FTP Task)
Determines how the component starts the SSL negotiation.
Data Type
Enumeration
Possible Values
Automatic (0)
Implicit (1)
Explicit (2)
None (3)
Default Value
0
Remarks
The SSLStartMode property may have one of the following values:
Automatic | If the remote port is set to the standard plaintext port of the protocol (where applicable), the task will behave the same as if SSLStartMode is set to Explicit. In all other cases, SSL negotiation will be implicit (Implicit). |
Implicit | The SSL negotiation will start immediately after the connection is established. |
Explicit | The task will first connect in plaintext, and then explicitly start SSL negotiation through a protocol command such as STARTTLS. |
None | No SSL negotiation, no SSL security. All communication will be in plaintext mode. |
Timeout Property (FTP 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).
TransferMode Property (FTP Task)
The transfer mode (ASCII or Binary). If the value is 0 (default), the initial server mode will be used.
Data Type
Enumeration
Possible Values
Default (0)
ASCII (1)
Binary (2)
Default Value
0
Remarks
The valid options for the TransferMode property are as follows:
Default | The initial mode of the FTP server is taken. No change. |
ASCII | Files are transferred in ASCII mode (TYPE A). |
Binary | Files are transferred in Binary mode (TYPE I). |
User Property (FTP Task)
The user id for login.
Data Type
String
Default Value
""
Remarks
This property must be set before the task connects to the FTP server.
UseSimpleDirList Property (FTP Task)
Instructs the component to issue the NLST command instead of LIST.
Data Type
Boolean
Default Value
false
Remarks
When this is set to true, the task will send the NLST command to the server. This tells the server to return a more simply formatted listing. If the server's directory listing can not be parsed when this is false, setting this to true will be helpful.
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 (FTP 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.FTP Config Settings
In many cases, FTP servers are not configured to return a valid public IP in the PASV response. When Secure Sockets Layer/Transport Layer Security (SSL/TLS) is used any network address translation (NAT) done by the firewall cannot occur. The result is the client may receive an IP that is not accessible.
This setting is designed to allow the connection to succeed in as many cases as possible. When the IP for the data connection is received from the server, the task will inspect the value. If the received value is not within the known private IP ranges, the task will use it, assuming it is a valid public IP. If the received value is a private IP, the task will instead assume the data connection should be established to the same IP as the command connection (true in almost all cases).
When this setting is False, the task will not perform any checks on the received value. When set to False, UseRemoteHostAddressForPassive is applicable.
NOTE: This setting is only applicable to the FTP Transmitter.
A,B,C,X=Y|RegEx
A,B,C, and X represent integer values that correspond to the capturing groups of the regular expression in the following order:
- FileName
- FileSize
- FileTime
- IsDir
Because group X represents the IsDir value, the user must specify Y to indicate what value that group must have in order for IsDir to be True.
Take, for instance, a simple entry in this format:
22 Test.txt
In this example, "22" is the FileSize and "Test.txt" is the FileName. To parse this entry, we will define the DirEntryPattern as follows:
2,1,-1,-1|([0-9]+)\s(.*)
The first value "2" indicates that the first field (FileName) corresponds to the second capturing group in the regular expression. The second value "1" indicates that the second field (FileSize) corresponds to the first capturing group in the regular expression. The capturing group is the regular expression in parenthesis. In the previous example, the first capturing group is ([0-9]+) and the second capturing group is (.*).
As seen in this example, -1 also can be specified as the integer value. When this is specified, that field is ignored.
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.
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.
Note that to avoid downloading the same subset of files each poll, either DownloadCacheFile or DeleteMode should also be used.
The range is provided as start-end, for instance: "1024-" stands for anything higher than 1024, "1024-2048" stands for ports between 1024 and 2048 inclusive, "4000-4010, 50000-50010" stands for ports between 4000 and 40010 or between 50000 and 50010.
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.
SSL Config Settings
If set to true, the task will reuse the context if and only if the following criteria are met:
- The target host name is the same.
- The system cache entry has not expired (default timeout is 10 hours).
- The application process that calls the function is the same.
- The logon session is the same.
- The instance of the task is the same.
Please note that this setting contains the minimum cipher strength requested from the security library.
Use this setting with caution. Requesting a lower cipher strength than necessary could potentially cause serious security vulnerabilities in your application.
By default, the enabled cipher suites will include all available ciphers ("*").
The special value "*" means that the task will pick all of the supported cipher suites. If SSLEnabledCipherSuites is set to any other value, only the specified cipher suites will be considered.
Multiple cipher suites are separated by semicolons.
Example values when UseInternalSecurityAPI is False (default):
// The "Other" property could contain ONE of the following lines:
SSLEnabledCipherSuites=*
SSLEnabledCipherSuites=CALG_AES_256
SSLEnabledCipherSuites=CALG_AES_256;CALG_3DES
Possible values when UseInternalSecurityAPI is False (default) include:
- CALG_3DES
- CALG_3DES_112
- CALG_AES
- CALG_AES_128
- CALG_AES_192
- CALG_AES_256
- CALG_AGREEDKEY_ANY
- CALG_CYLINK_MEK
- CALG_DES
- CALG_DESX
- CALG_DH_EPHEM
- CALG_DH_SF
- CALG_DSS_SIGN
- CALG_ECDH
- CALG_ECDH_EPHEM
- CALG_ECDSA
- CALG_ECMQV
- CALG_HASH_REPLACE_OWF
- CALG_HUGHES_MD5
- CALG_HMAC
- CALG_KEA_KEYX
- CALG_MAC
- CALG_MD2
- CALG_MD4
- CALG_MD5
- CALG_NO_SIGN
- CALG_OID_INFO_CNG_ONLY
- CALG_OID_INFO_PARAMETERS
- CALG_PCT1_MASTER
- CALG_RC2
- CALG_RC4
- CALG_RC5
- CALG_RSA_KEYX
- CALG_RSA_SIGN
- CALG_SCHANNEL_ENC_KEY
- CALG_SCHANNEL_MAC_KEY
- CALG_SCHANNEL_MASTER_HASH
- CALG_SEAL
- CALG_SHA
- CALG_SHA1
- CALG_SHA_256
- CALG_SHA_384
- CALG_SHA_512
- CALG_SKIPJACK
- CALG_SSL2_MASTER
- CALG_SSL3_MASTER
- CALG_SSL3_SHAMD5
- CALG_TEK
- CALG_TLS1_MASTER
- CALG_TLS1PRF
// The "Other" property could contain ONE of the following lines:
SSLEnabledCipherSuites=*
SSLEnabledCipherSuites=TLS_DHE_DSS_WITH_AES_128_CBC_SHA
SSLEnabledCipherSuites=TLS_DHE_DSS_WITH_AES_128_CBC_SHA;TLS_DH_ANON_WITH_AES_128_CBC_SHA
Possible values when UseInternalSecurityAPI is True include:
- TLS_DHE_DSS_WITH_AES_128_GCM_SHA256
- TLS_DHE_DSS_WITH_AES_256_GCM_SHA384
- TLS_DHE_DSS_WITH_3DES_EDE_CBC_SHA
- TLS_DHE_DSS_WITH_AES_128_CBC_SHA
- TLS_DHE_DSS_WITH_AES_128_CBC_SHA256
- TLS_DHE_DSS_WITH_AES_256_CBC_SHA
- TLS_DHE_DSS_WITH_AES_256_CBC_SHA256
- TLS_DHE_DSS_WITH_DES_CBC_SHA
- TLS_DHE_RSA_WITH_AES_128_GCM_SHA256
- TLS_DHE_RSA_WITH_AES_256_GCM_SHA384
- TLS_DHE_RSA_WITH_3DES_EDE_CBC_SHA
- TLS_DHE_RSA_WITH_AES_128_CBC_SHA
- TLS_DHE_RSA_WITH_AES_128_CBC_SHA256
- TLS_DHE_RSA_WITH_AES_256_CBC_SHA
- TLS_DHE_RSA_WITH_AES_256_CBC_SHA256
- TLS_DHE_RSA_WITH_DES_CBC_SHA
- TLS_RSA_WITH_AES_256_GCM_SHA384
- TLS_RSA_WITH_AES_128_GCM_SHA256
- TLS_RSA_WITH_3DES_EDE_CBC_SHA
- TLS_RSA_WITH_AES_128_CBC_SHA
- TLS_RSA_WITH_AES_128_CBC_SHA256
- TLS_RSA_WITH_AES_256_CBC_SHA
- TLS_RSA_WITH_AES_256_CBC_SHA256
- TLS_RSA_WITH_DES_CBC_SHA
- TLS_RSA_WITH_RC4_128_MD5
- TLS_RSA_WITH_RC4_128_SHA
If SSLEnabledProtocols is configured to use TLS 1.3 the following values are supported:
- TLS_AES_128_GCM_SHA256
- TLS_AES_256_GCM_SHA384
SSLEnabledCipherSuites is used together with SSLCipherStrength.
Not all supported protocols are enabled by default (the value of this setting is 4032). If you want more granular control over the enabled protocols, you can set this property to the binary 'OR' of one or more of the following values:
TLS1.3 | 12288 (Hex 3000) (Experimental) |
TLS1.2 | 3072 (Hex C00) (Default) |
TLS1.1 | 768 (Hex 300) (Default) |
TLS1 | 192 (Hex C0) (Default) |
SSL3 | 48 (Hex 30) |
SSL2 | 12 (Hex 0C) |
Note: TLS 1.1 and TLS1.2 support are only available starting with Windows 7.
Note: Enabling TLS 1.3 will automatically set UseInternalSecurityAPI to True.
If set to True all certificates returned by the server will be present in the transport log. This includes the leaf certificate, any intermediate certificate, and the root certificate.
Note: When UseInternalSecurityAPI is set to True this value is automatically set to True. This is needed for proper validation when using the internal provider.
0x00000001 | Ignore time validity status of certificate. |
0x00000002 | Ignore time validity status of CTL. |
0x00000004 | Ignore non-nested certificate times. |
0x00000010 | Allow unknown Certificate Authority. |
0x00000020 | Ignore wrong certificate usage. |
0x00000100 | Ignore unknown certificate revocation status. |
0x00000200 | Ignore unknown CTL signer revocation status. |
0x00000400 | Ignore unknown Certificate Authority revocation status. |
0x00000800 | Ignore unknown Root revocation status. |
0x00008000 | Allow test Root certificate. |
0x00004000 | Trust test Root certificate. |
0x80000000 | Ignore non-matching CN (certificate CN not-matching server name). |
When specified the task will verify that the server certificate signature algorithm is among the values specified in this setting. If the server certificate signature algorithm is unsupported the task will fail with an error.
The format of this value is a comma separated list of hash-signature combinations. For instance:
// The "Other" could contain ALL of these lines:
UseInternalSecurityAPI=true
SSLEnabledProtocols=3072
TLS12SignatureAlgorithms=sha1-rsa,sha1-dsa,sha256-rsa,sha256-dsa
The default value for this setting is "sha1-rsa,sha1-dsa,sha224-rsa,sha224-dsa,sha256-rsa,sha256-dsa,sha384-rsa,sha384-dsa,sha512-rsa,sha512-dsa".
In order to not restrict the server's certificate signature algorithm, specify an empty string as the value for this setting, which will cause the signature_algorithms TLS 1.2 extension to not be sent.
The default value is ecdhe_secp256r1,ecdhe_secp384r1,ecdhe_secp521r1.
When using TLS 1.2 and UseInternalSecurityAPI is set to True, the values refer to the supported groups for ECC. The following values are supported:
- "ecdhe_secp256r1" (default)
- "ecdhe_secp384r1" (default)
- "ecdhe_secp521r1" (default)
The default value is set to balance common supported groups and the computational resources required to generate key shares. As a result only some groups are included by default in this setting.
Note: All supported groups can always be used during the handshake even if not listed here, but if a group is used which is not present in this list it will incur an additional round trip and time to generate the key share for that group.
In most cases this setting does not need to be modified. This should only be modified if there is a specific reason to do so.
The default value is ecdhe_x25519,ecdhe_secp256r1,ecdhe_secp384r1,ffdhe_2048,ffdhe_3072
The values are ordered from most preferred to least preferred. The following values are supported:
- "ecdhe_x25519" (default)
- "ecdhe_x448"
- "ecdhe_secp256r1" (default)
- "ecdhe_secp384r1" (default)
- "ecdhe_secp521r1"
- "ffdhe_2048" (default)
- "ffdhe_3072" (default)
- "ffdhe_4096"
- "ffdhe_6144"
- "ffdhe_8192"
- "rsa_pkcs1_sha256" (default)
- "rsa_pkcs1_sha384" (default)
- "rsa_pkcs1_sha512" (default)
The default value is ecdhe_x25519,ecdhe_x448,ecdhe_secp256r1,ecdhe_secp384r1,ecdhe_secp521r1,ffdhe_2048,ffdhe_3072,ffdhe_4096,ffdhe_6144,ffdhe_8192
The values are ordered from most preferred to least preferred. The following values are supported:
- "ecdhe_x25519" (default)
- "ecdhe_x448" (default)
- "ecdhe_secp256r1" (default)
- "ecdhe_secp384r1" (default)
- "ecdhe_secp521r1" (default)
- "ffdhe_2048" (default)
- "ffdhe_3072" (default)
- "ffdhe_4096" (default)
- "ffdhe_6144" (default)
- "ffdhe_8192" (default)
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.