Solved

SSIS ETL from Sharepoint

Posted on 2013-05-30
3
902 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now