Export sharepoint list data to SQL 2005

• nazaninahmady_sh

  Default port

  Points: 1465

  More actions

  November 27, 2008 at 3:56 am

  #125235

  hello

  i want to Export sharepoint list data to SQL server 2005, for this purpose i use

  http://www.devx.com/dotnet/Article/35070

  this is very useful for me, but i have two problem, in Page 2 (at the end of the page , it is written page two: Creating Your Web Service Proxy), that is written:

  Creating Your Web Service Proxy

  To begin creating the sample application, open Visual Studio and create a new project of type "Class Library," and ....

  like Figure one,

  i dont have Visual basic, C# and.... in my templates in Bussine Intelligence

  and i dont know why?

  and another quesion is that in Figure 2 , in sample, where the writer wants to introduce a URL to web Refrence , at the end of that line, it is written asmx, my question is that what is asmx? i dont have it , my address is http://iribportal/Lists/List/Allitemsg.aspx (at the end i have aspx not asmx)

  so when i write the URL in address line and click go ,

  it can not find any web services,

  please help me,

  regards

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  June 8, 2010 at 4:25 pm

  #1177727

  If you can use third-party solutions, check the commercial CozyRoc SharePoint integration. These are the relevant components:

  * SharePoint Source SSIS Data Flow Component

  * SharePoint Destination SSIS Data Flow Component

  * SharePoint SSIS Connection Manager

  Batch insert and update is also supported.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/