Hi,<br/><br/>I need to figure out how to export rows from a SharePoint List to SSIS 2008 - as views.<br/><br/>Has anyone tried this before?<br/><br/>Anne-Dorthe© 2009 Microsoft Corporation. All rights reserved.Fri, 03 Jul 2009 07:28:42 Za1c63df9-1a11-4a10-bd9d-401eef83553ehttp://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#a1c63df9-1a11-4a10-bd9d-401eef83553ehttp://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#a1c63df9-1a11-4a10-bd9d-401eef83553eAnne-Dorthehttp://social.msdn.microsoft.com/Profile/en-US/?user=Anne-DortheHi,<br/><br/>I need to figure out how to export rows from a SharePoint List to SSIS 2008 - as views.<br/><br/>Has anyone tried this before?<br/><br/>Anne-DortheFri, 26 Jun 2009 09:28:22 Z2009-06-26T09:28:22Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#b52569b1-e0c9-4fdf-9498-2f258d6c4508http://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#b52569b1-e0c9-4fdf-9498-2f258d6c4508Serge Luca [MVP]http://social.msdn.microsoft.com/Profile/en-US/?user=Serge%20Luca%20%5bMVP%5djust an idea : maybe by exporting the list to an Excel spreadsheet; and from Excel to SSIS ?<br/> <br/><hr class="sig">Serge Luca; blog: http://www.redwood.be Fri, 26 Jun 2009 09:40:03 Z2009-06-26T09:40:03Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#2b537c9a-7f5b-4fc0-8f33-d6c058bd49f7http://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#2b537c9a-7f5b-4fc0-8f33-d6c058bd49f7Anne-Dorthehttp://social.msdn.microsoft.com/Profile/en-US/?user=Anne-DortheHi Serge,<br/><br/>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?<br/><br/>ADFri, 26 Jun 2009 09:55:59 Z2009-06-26T09:55:59Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#464a8c21-2843-49bd-adb6-f60dc6bd0eaehttp://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#464a8c21-2843-49bd-adb6-f60dc6bd0eaeSerge Luca [MVP]http://social.msdn.microsoft.com/Profile/en-US/?user=Serge%20Luca%20%5bMVP%5dIndeed, but as far as I know the alternative is to write .Net code.<br/><hr class="sig">Serge Luca; blog: http://www.redwood.be Fri, 26 Jun 2009 10:03:33 Z2009-06-26T10:03:33Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#edcb6edb-f8d3-4e7b-965d-82f33ea9a381http://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/a1c63df9-1a11-4a10-bd9d-401eef83553e#edcb6edb-f8d3-4e7b-965d-82f33ea9a381Sid Atkinson - Catapult Systemshttp://social.msdn.microsoft.com/Profile/en-US/?user=Sid%20Atkinson%20-%20Catapult%20SystemsCheck my two posts here: <br/>- <a href="http://www.sidatkinson.com/post/2008/09/19/SSIS-Adapter-for-SharePoint.aspx">http://www.sidatkinson.com/post/2008/09/19/SSIS-Adapter-for-SharePoint.aspx</a> - - references a CodePlex plugins for SSIS to do just this<br/>- <a href="http://www.sidatkinson.com/post/2007/10/25/Extracting-SharePoint-Data-using-SSIS.aspx">http://www.sidatkinson.com/post/2007/10/25/Extracting-SharePoint-Data-using-SSIS.aspx</a> -- an older post pre-CodePlex project on how to use the Script Task to accomplish this<br/><br/>Post back with questions/comments<hr class="sig"><p><a href="http://sidatkinson.com" title="Business Intelligence and SQL Server">BI and SQL Blog</a></p> <br/> Please click the <b><i>Mark as Answer</i></b> button if a post solves your problem!Wed, 01 Jul 2009 20:19:17 Z2009-07-01T20:19:17Z