Exporting rows from SharePoint to SSIS

Question

Hi,

I need to figure out how to export rows from a SharePoint List to SSIS 2008 - as views.

Has anyone tried this before?

Anne-Dorthe

Answer 1

just an idea : maybe by exporting the list to an Excel spreadsheet; and from Excel to SSIS ?

---

Serge Luca; blog: http://www.redwood.be

Answer 2

Hi Serge,

I had the same idea, but then I thought it might not be the proper solution if I have to do it more than one time... What do you think?

AD

Answer 3

Indeed, but as far as I know the alternative is to write .Net code.

---

Serge Luca; blog: http://www.redwood.be

Answer 4

Check my two posts here:
- http://www.sidatkinson.com/post/2008/09/19/SSIS-Adapter-for-SharePoint.aspx - - references a CodePlex plugins for SSIS to do just this
- http://www.sidatkinson.com/post/2007/10/25/Extracting-SharePoint-Data-using-SSIS.aspx -- an older post pre-CodePlex project on how to use the Script Task to accomplish this

Post back with questions/comments

---

BI and SQL Blog

Please click the Mark as Answer button if a post solves your problem!