Lists are one of the cornerstones of SharePoint and many companies have a wealth of information stored and managed using this SharePoint feature. I sometimes get questions whether it is possible to extract that data (or load that data) into a data warehouse or a cube elsewhere. The answer is yes, using the SharePoint SSIS Adapters. Please follow this link for additional details on how to do it.
Reading and Loading SharePoint Data using SSIS
business intelligist 