SharePoint Source

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Join VIP ----- Questions?

Overview

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


Demonstration

Demonstration VideoDemonstration Video

Setup

Use the parameters below to set up the component.

Parameters

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 a SharePoint list.

InputQuery

Specify a CAML query statement. This parameter is optional.

InputView

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

IncludeFolders

Indicate that the folders should be included in the result list. The default is false.

IsRecursive

Indicate that sub-folder items should be included in the result list. The default is false.

IncludeHidden (1.5 SR-2)

Indicate that hidden list fields should be included. The default is false.

How to modify the source dynamically at runtime

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

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

Related scripts