Extracting and Loading SharePoint Data in SQL Server Integration Services

By Kevin Idzi, Software Development Engineer, Microsoft Corporation

Applies to: Microsoft SQL Server 2005, 2008, 2008 R2, and 2012

Summary:

The SharePoint List Source and Destination Sample available on Codeplex provides an optimized solution with an easy-to-use interface for getting data out of or into a SharePoint list. The sample also includes an API for accomplishing these tasks efficiently outside of SQL Server Integration Services.

This article introduces the SharePoint List Source and Destination adapters, demonstrates their use in an SSIS package, and documents their features and options.

To download the adapters themselves, visit the Microsoft SQL Server Community Samples: Integration Services page on Codeplex.

To review the document, please download the Word document Extracting and Loading SharePoint Data in SQL Server Integration Services.