Exporting rows from SharePoint to SSIS
- 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
解答
- 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
Please click the Mark as Answer button if a post solves your problem!- 已標示為解答Lu Zou-MSFTMSFT, 版主Friday, 3 July, 2009 7:28
所有回覆
- just an idea : maybe by exporting the list to an Excel spreadsheet; and from Excel to SSIS ?
Serge Luca; blog: http://www.redwood.be - 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 - Indeed, but as far as I know the alternative is to write .Net code.
Serge Luca; blog: http://www.redwood.be - 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
Please click the Mark as Answer button if a post solves your problem!- 已標示為解答Lu Zou-MSFTMSFT, 版主Friday, 3 July, 2009 7:28
