SharePoint Source

Overview

SharePoint Source Component is SSIS Data Flow Component for consuming data from SharePoint Service. The configuration options are provided in the standard data flow source component dialog.

Setup

Use the options below to setup the component.

Options

SHAREPOINT

Select an existing SharePoint connection manager.

Related Topics: SharePoint Connection Manager

BatchSize

Specify the number of rows to be retrieved as a batch. The maximum is 5000.

InputList

Select SharePoint list.

InputQuery

Specify CAML query statement. This property is optional.

InputView

Select SharePoint list view to use for input. This property is optional

IncludeFolders

Specify to include the folders in the result list. The default is false.

IsRecursive

Specify to include sub-folders items in the result list. The default is false.

IncludeHidden (1.5 SR-2)

Specify to include hidden list fields. The default is false.

How to modify source dynamically at runtime?

The source list or query are available in the data flow properties list. Follow these steps to setup expression:

  • Right-click on data flow canvas and select Properties menu.
  • Scroll-down and find property named like [SharePoint Source].[InputList]. This is the property containing the input SharePoint list.
  • Scroll-down and find property named like [SharePoint Source].[InputQuery]. This is the property containing the CAML query.
  • Scroll-down and find Expressions property. Setup expression to modify the above properties dynamically.