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.
AuthScheme | The authorization scheme to be used when server authorization is to be performed. |
Delete | Controls if the remote file is deleted after download. |
Depth | How deep the server should operate within a directory. |
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 server. |
Firewall | A set of properties related to firewall access. |
HTTPProxy | A set of properties related to proxy access. |
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 task execution. |
Operation | The operation which will be executed by the task. |
Other | Defines a set of configuration settings to be used by the task. |
Overwrite | Whether or not the component should overwrite files during transfer. |
Password | The password for login. |
RuntimeLicense | Specifies the task runtime license key. |
SSLAcceptServerCert | Instructs the task to unconditionally accept the server certificate that matches the supplied certificate. |
SSLAcceptServerCertAcceptAny | Tells the task to accept any server certificate. |
SSLCert | The certificate to use for client authentication during the SSL handshake. |
Timeout | A timeout for the task. |
URL | The URL of the WebDAV location to which the request is made. |
User | The 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.
AuthScheme | The authorization scheme to be used when server authorization is to be performed. |
Firewall | A set of properties related to firewall access. |
HTTPProxy | A set of properties related to proxy 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 task execution. |
Other | Defines a set of configuration settings to be used by the task. |
Password | The password for login. |
RemoteFile | The name of the destination file on the server for uploading. |
RuntimeLicense | Specifies the task runtime license key. |
SSLAcceptServerCert | Instructs the task to unconditionally accept the server certificate that matches the supplied certificate. |
SSLAcceptServerCertAcceptAny | Tells the task to accept any server certificate. |
SSLCert | The certificate to use for client authentication during the SSL handshake. |
Timeout | A timeout for the task. |
URL | The URL of the WebDAV location to which the request is made. |
User | The 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.
Authorization | The Authorization string to be sent to the server. |
FollowRedirects | Determines what happens when the server issues a redirect. |
TempURL | A temporary location on the server to store files before moving them to URL. |
LocalFile | The name of the LocalFile to which the remote file will be saved. |
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 task should consider metadata differences when deciding whether to download a file again. |
RenameTo | A filename to which RemoteFile will be renamed. |
RenameMode | The condition under which RenameTo is used. |
TemporaryDownloadExtension | An extension to be appended during download. |
TemporaryUploadExtension | An extension to be appended during upload. |
ReuseSSLSession | Determines if the SSL session is reused. |
SSLCipherStrength | The minimum cipher strength used for bulk encryption. |
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. |
SSLEnabledCipherSuites | The cipher suite to be used in an SSL negotiation. |
TLS12SignatureAlgorithms | Defines the allowed TLS 1.2 signature algorithms when UseInternalSecurityAPI is True. |
TLSNamedGroups | The supported (EC)DHE groups. |
TLS13SignatureAlgorithms | The allowed certificate signature algorithms. |
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 | Tells the task whether or not to use the system security libraries or an internal implementation. |