Solved

SSIS ETL from Sharepoint

Posted on 2013-05-30
3
959 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

630 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