Using the Azure Files Source Component

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

  • General Page
  • Columns Page

General page

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

Azure Files Source Editor

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 specifies 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.
Page Size
The Page Size lets you specify how many records to retrieve per service call to Azure Files instance. The default is set to 1000.
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 update of the property at run time.
Generate Documentation Icon
Click the Generate Documentation icon to generate a Word document which 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.

Azure Files Source Editor

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

The Columns Page grid consists of:

  • Azure Files Field: Column that will be retrieved from the current item (file or folder).
  • Data Type: The data type of this field.

Note: As a general best practice, you should only select the Azure Files fields that are needed for the downstream pipeline components.

Add button on the top of the grid opens u a new window in which you can choose to add additional metadata fields as shown below.

Azure Files Source - Add Meta