Solved

SSIS ETL from Sharepoint

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 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