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 anyo开发者_如何学编程ne refer me to the right tutorial?

Thanks. :)

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.