Solved

SSIS ETL from Sharepoint

Posted on 2013-05-30
3
913 Views
Last Modified: 2016-10-12
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.
0
Comment
Question by:saved4use
3 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 39208716
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
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 39210260
RainerJ, It's good one. Thanks
0
 

Expert Comment

by:Paul Gallagher
ID: 41839909
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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question