SharePoint Destination

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

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

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

Overview

The SharePoint Destination Component is an SSIS Data Flow Component for loading data into a Microsoft SharePoint list. The configuration parameters are provided in the standard data flow destination component dialog.


Setup

Use the parameters below to set up the component.

Parameters

SHAREPOINT

Select an existing SharePoint connection manager.

Related Topics: SharePoint Connection Manager

Action

Select the destination list action. This parameter has the options listed in the following table.

Action Description
Create Create a new item in the destination list.
Update Update an existing item in the destination list. The appropriate list item identifier must be specified in order for the update to work.
Delete Delete an existing item from the destination list. The appropriate list item identifier must be specified in order for the delete to work.


Note: After changing the action, you must use the Refresh command in the 'Column Mappings' tab to reload the destination list metadata.

DestinationList

Specify the destination SharePoint list where the data is to be loaded.

ErrorRowDisposition (SharePoint Destination Input)

Specify how to handle rows with errors.

How to modify the destination list dynamically at runtime

The SharePoint destination list is 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 Destination].[DestinationList]. This is the property containing the destination list.
  • Scroll down and find the Expressions property. Set up an expression to modify the statement dynamically.

Related scripts