Overview
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 Component dialogs.
Demonstration
Quick Start
In this section we will show you how to set up a SharePoint Destination component. Note that the File Transfer Task should be used if you wish to upload files to SharePoint.
- Before you begin, drag the Data Flow Task onto the Control Flow canvas.
- Double-click on the Data Flow Task to go to the Data Flow canvas.
- Configure a SharePoint connection manager.
- Configure a source component that will provide the data to be written to SharePoint. If your input contains a Date/Time column, ensure that the datatype is set to DT_DBTIMESTAMP.
- In the SSIS Toolbox, locate the SharePoint Destination component and drag it onto the Data Flow canvas.
- Connect the blue arrow from the source component to the SharePoint Destination component.
- Double-click on the SharePoint Destination component.
- Once the component editor opens, in the Connection Managers tab, select the connection manager you configured earlier from the Connection drop-down list.
- Click on the Component Properties tab in the component editor.
- Choose the desired Action (Create, Update, or Delete). In this example, we chose the Create action.
- Choose the DestinationList you will be working with. We chose the Calendar DestinationList in this example.
- Click OK to close the component editor.
Congratulations! You have successfully configured the SharePoint Destination component.
Parameters
Configuration
Use the parameters below to configure the component.
Select an existing SharePoint connection manager.
Related Topics: SharePoint Connection Manager
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. After changing the action, you must use the Refresh command in the 'Column Mappings' tab to reload the destination list metadata.Specify the destination SharePoint list where the data is to be loaded.
Specify the number of rows to be sent as a batch. The maximum is 500.
Specify how to handle rows with errors.
Specifies how NULL values are handled. This parameter has the options listed in the following table.
Options Description True The NULL values are ignored and not sent for processing. False The NULL values are sent for processing.
Knowledge Base
- Where can I find the documentation for the SharePoint Destination?
- How to pass a multiple choices to a MULTI-CHOICE SharePoint Column?
- How to change a folder name in a Sharepoint document library.
- Error Message: 'The remote server returned an error (429)' when using Sharepoint Online.
- Error Message: The operation has timed out.
What's New
- New: Support for updating read-only fields.
- New: An enhanced configuration dialog with improved columns mapping page.
- New: A new parameter IgnoreNullValue.
- New: Component now shows user-friendly names for columns containing spaces (Thank you, Michael).
- Fixed: Component inserted incomplete date columns.
- New: Introduced component.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.