/n software Tasks for SSIS
/n software Tasks for SSIS
Questions / Feedback?

WebDAV Tasks

Properties   Configuration Settings  

The WebDAV Task adds SSL-enabled WebDAV send and receive capabilities to your SSIS Package.

Remarks

The WebDAV Task provides support for uploading and downloading files to and from a WebDAV server.

WebDAV Receive Task

The WebDAV Receive Task is used to download files from the WebDAV Server. To begin set the URL and FileMask properties.

URL should be set to the URL including the directory from which the files will be downloaded. For instance: https://www.test.com/DAV/pictures/animals/cats/

FileMask should be set to a pattern like *.png. The task will download files matching the specified pattern. The default value is *.*.

The Depth property specifies how deep the server should operate within a directory.

Authentication to the WebDAV server is supported by setting User and Password. A Variety of authentication methods are supported via the AuthScheme property.

The task will connect to the WebDAV server and list the directory at URL. All files that match the FileMask will be downloaded and submitted to the SSIS Package as individual messages.

In order to guarantee that files are not downloaded multiple times, you may set the DeleteMode. Alternatively, you may use the Other property to configure either the DownloadCacheFile and EnableFileDetailsComparison settings, or the RenameTo and RenameMode settings.

WebDAV Send Task

The WebDAV Send Task is used to upload files to the WebDAV Server. To begin set the URL and RemoteFile properties.

URL should be set to the URL including the directory from which the files will be downloaded. For instance: https://www.test.com/DAV/pictures/animals/cats/

RemoteFile should be set to the name of the file to be uploaded. For instance %RemoteFile%.

Authentication to the WebDAV server is supported by setting User and Password. A Variety of authentication methods are supported via the AuthScheme property.

The task will connect to the WebDAV server whenever it has a message to send. The task will attempt to upload to a resource URI generated based on the values of URL and RemoteFile.

In order to prevent parallel processing by another application before your upload is complete, you may need to set a temporary extension via TemporaryUploadExtension.

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.

AuthSchemeThe authorization scheme to be used when server authorization is to be performed.
DeleteControls if the remote file is deleted after download.
DepthHow deep the server should operate within a directory.
DirListString denoting the name of the variable which contains the last directory listing entries.
FileMaskIndicates the type of files to download from the server.
FirewallA set of properties related to firewall access.
HTTPProxyA set of properties related to proxy access.
LocalDirectoryThe directory on the local machine to write downloaded files to.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during task execution.
OperationThe operation which will be executed by the task.
OtherDefines a set of configuration settings to be used by the task.
OverwriteWhether or not the component should overwrite files during transfer.
PasswordThe password for login.
RuntimeLicenseSpecifies the task runtime license key.
SSLAcceptServerCertInstructs the task to unconditionally accept the server certificate that matches the supplied certificate.
SSLAcceptServerCertAcceptAnyTells the task to accept any server certificate.
SSLCertThe certificate to use for client authentication during the SSL handshake.
TimeoutA timeout for the task.
URLThe URL of the WebDAV location to which the request is made.
UserThe user id for login.

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.

AuthSchemeThe authorization scheme to be used when server authorization is to be performed.
FirewallA set of properties related to firewall access.
HTTPProxyA set of properties related to proxy access.
LocalFileThe path to a local file for upload.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during task execution.
OtherDefines a set of configuration settings to be used by the task.
PasswordThe password for login.
RemoteFileThe name of the destination file on the server for uploading.
RuntimeLicenseSpecifies the task runtime license key.
SSLAcceptServerCertInstructs the task to unconditionally accept the server certificate that matches the supplied certificate.
SSLAcceptServerCertAcceptAnyTells the task to accept any server certificate.
SSLCertThe certificate to use for client authentication during the SSL handshake.
TimeoutA timeout for the task.
URLThe URL of the WebDAV location to which the request is made.
UserThe user id for login.

Configuration Settings


The following is a list of configuration settings for the task with short descriptions. Click on the links for further details.

AuthorizationThe Authorization string to be sent to the server.
FollowRedirectsDetermines what happens when the server issues a redirect.
TempURLA temporary location on the server to store files before moving them to URL.
LocalFileThe name of the LocalFile to which the remote file will be saved.
DownloadCacheFileWhen set, only new files will be downloaded from the server.
DownloadCacheFileDurationThe number of minutes that a file name will remain in the download cache.
EnableFileDetailsComparisonWhether the receive task should consider metadata differences when deciding whether to download a file again.
RenameToA filename to which RemoteFile will be renamed.
RenameModeThe condition under which RenameTo is used.
TemporaryDownloadExtensionAn extension to be appended during download.
TemporaryUploadExtensionAn extension to be appended during upload.
ReuseSSLSessionDetermines if the SSL session is reused.
SSLCipherStrengthThe minimum cipher strength used for bulk encryption.
SSLEnabledProtocolsUsed to enable/disable the supported security protocols.
SSLIncludeCertChainWhether the entire certificate chain is included in the SSLServerAuthentication event.
SSLSecurityFlagsFlags that control certificate verification.
SSLEnabledCipherSuitesThe cipher suite to be used in an SSL negotiation.
TLS12SignatureAlgorithmsDefines the allowed TLS 1.2 signature algorithms when UseInternalSecurityAPI is True.
TLSNamedGroupsThe supported (EC)DHE groups.
TLS13SignatureAlgorithmsThe allowed certificate signature algorithms.
AbsoluteTimeoutDetermines whether timeouts are inactivity timeouts or absolute timeouts.
LocalHostThe name of the local host or user-assigned IP interface through which connections are initiated or accepted.
TcpNoDelayWhether or not to delay when sending packets.
UseInternalSecurityAPITells the task whether or not to use the system security libraries or an internal implementation.

 
 
Copyright (c) 2019 /n software inc. - All rights reserved.
/n software Tasks for SSIS - Version 16.0 [Build 7240]