CODEWITHSUNDEEP
sql-serversharepointssis
janejanejane
janejanejane

Reputation: 496

How can I export data from SQL Server 2005 to a SharePoint list in batches?

I was told that this could be done by using SSIS. Can anyone refer me to the right tutorial?

Thanks. :)

Upvotes: 1

Views: 739

Answers (1)

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17353

Extracting and Loading SharePoint Data in SQL Server Integration Services

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.

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.

Upvotes: 4

Related Questions