Help Manual - WebDAV Source

Documentation on SSIS WebDAV Source component

Using the WebDAV Source Component

The WebDAV Source Component is a data flow component that can be used to read or extract data from a WebDAV instance.
There are two pages that can be configured:

  • General
  • Columns

General Page

This page has the general settings to be configured for the component.

WebDAV Source Editor - General

Source Item Settings
Connection Manager

Choose the connection manager from the list to specify the one you wish to work with.

Source Item Path

The Source Item Path specifies the location of the file or folder that you are trying to read from.

Item Selection Mode

The Item Selection Mode settings specify what sub-items (if any) you wish to retrieve. The available modes are:

  • Selected Item: Retrieves only the item specified at Source Item Path.
  • Recursive: Retrieves the item specified at Source Item Path and its sub-items recursively.
  • Selected Level: Retrieves the item specified at Source Item Path and its sub-items.
  • Recursive (Files Only): Selects items the same as the Recursive mode but only returns files.
  • Selected Level (Files Only): Selects items the same as the Selected Level mode but only returns files.
Refresh Component Button

Clicking the Refresh Component button causes the component to retrieve the latest metadata and update each field to its most recent metadata.

Expression fx Icon

Click the blue fx icon to launch SSIS Expression Editor to enable dynamic updates of the property at run time.

Generate Documentation Icon

Click the Generate Documentation icon to generate a Word document that describes the component's metadata including relevant mapping, and so on.

Columns Page

The Columns page of the Source Component shows you all available attributes from the object that you specified on the General page.

WebDAV Source Editor - Columns

On the top left of the grid, you can see a checkbox, which can be used to toggle the selection of all available fields. This is a productive way to check or uncheck all available fields.
The Columns Page grid consists of:

  • WebDAV Field: Column that will be retrieved from the current item (file or folder). There are a few important fields worth mentioning:
    • FileContent: If the current item is a file, this will return the binary content of the file
    • FullPath: The path to the current item
    • IsDirectory: A boolean specifying if the current item is a folder
    • Name: The name of the current item
  • Data Type: The data type of this field.