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.
Use the parameters below to set up the component.
Select an existing SharePoint connection manager.
Related Topics: SharePoint Connection Manager
Specify the number of rows to be retrieved as a batch. The maximum is 5000.
Select a SharePoint list.
Specify a CAML query statement. This parameter is optional.
Select the SharePoint list view to use for input. This parameter is optional.
Indicate that the folders should be included in the result list. The default is false.
Indicate that sub-folder items should be included in the result list. The default is false.
Indicate that hidden list fields should be included. The default is false.
The source list or query are available in the data flow properties list. Follow these steps to set up an expression: