SSIS ETL from Sharepoint

I would like to extract data from a Sharepoint list/form and load it into a SQL server table for reporting using SSIS. How can I do/accomplish this? A step-by-step guide or clear instructions would be ideal.
Thank you.
saved4useAsked:
Who is Participating?
 
Rainer JeschorConnect With a Mentor Commented:
Hi,
there is a Codeplex solution (programmed and provided by MS SQL Team) to extract or load data to SharePoint lists.
Whitepaper can be found here:
http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SharePoint%20SSIS%20Adapters%202011.docx

Download of the adapters as well as readme:
http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

Another helpful article:
http://dataqueen.unlimitedviz.com/2011/06/how-to-use-a-sharepoint-list-as-a-data-source-in-your-ssis-package/

HTH
Rainer
0
 
Alpesh PatelAssistant ConsultantCommented:
RainerJ, It's good one. Thanks
0
 
Paul GallagherCommented:
AxioWOrks SQList product can replicate data to normalised SQL Server tables and keep them in synch. All the tables are created and maintained automatically by the product.
Take a look at http://www.axioworks.com/sqlist
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.