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
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.