SharePoint Destination

Overview

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

Setup

Use the options below to setup the component.

Options

SHAREPOINT

Select an existing SharePoint connection manager.

Related Topics: SharePoint Connection Manager

Action

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

Action	Description
Create	Create new item in the destination list.
Update	Update existing item in the destination list. You have to specify the appropriate list item identifier for the update to work.
Delete	Delete existing item from the destination list. You have to specify the appropriate list item identifier for the delete to work.

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

DestinationList

Specify the destination SharePoint list where the data is loaded.

ErrorRowDisposition (SharePoint Destination Input)

Specify how to handle rows with errors.

How to modify destination list dynamically at runtime?

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