Integrating SharePoint Data with SQL Server

May 1, 2009

With SharePoint’s growing popularity in the business world, it’s become an important repository of data. However, this data is often isolated from the rest of an organization’s data system. But by using the native web-service calls in Windows SharePoint Services (WSS), you can access SharePoint list data and use SQL Server Integration Services (SSIS) to transform the resulting dataset from an XML source to a relational database table.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=101656