[From SQL Server Magazine
With SharePoints growing popularity in the business world, its become an important repository of data. However, this data is often isolated from the rest of an organizations 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