Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
How to copy sharepoint list data into SQL server Database

Întrebare How to copy sharepoint list data into SQL server Database

  • Monday, January 21, 2013 7:58 AM
     
     
    Sign In to Vote
    0

    I have developed SharePoint 2010 Claims Based Applicaton. Also I am using SQL server 2008 R2 server.

    I need to generate report with SharePoint lIst data using SSRS.

    BIDS is connecting with SQL server Content Database. But sharepoint list is stored in that Content DB. But i could not find that sharepoint value. so..

    How to copy/save SharePoint list data into SQL server Database?


     

All Replies

  • Tuesday, January 22, 2013 6:38 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Kanthavel,

    We can use SQL Server Integration Services to load data from SharePoint to SQL Server, please download word document for detail steps.

    http://msdn.microsoft.com/en-us/library/hh368261.aspx

    Allen Li
    TechNet Community Support

     
  • Tuesday, January 22, 2013 9:36 AM
     
     
    Sign In to Vote
    0

    Hi Allen,

    Thank you for your reply.

      I can create SSIS package for Classic Mode SharePoint Application. But I could not create SSIS for Claims based SharePoint Applications. I require SSIS for Claims Based Application only.

    I got the "The HTTP request  was forbidden with client authentication scheme Ntlm. the remote server returned an error (403) forbidden". Please refer the below link which shows  my error msg.

         christianbahnsen.com/sharepoint_source_error_message.pdf

    kindly solve my issue. Is there any extra configuration required for Claims Based SharePoint 2010 Application to create SSIS package?