Monday, January 21, 2013 7:58 AM
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?
- Edited by Kanthavel Sekar Monday, January 21, 2013 10:00 AM Edit
Tuesday, January 22, 2013 6:38 AMModerator
We can use SQL Server Integration Services to load data from SharePoint to SQL Server, please download word document for detail steps.
TechNet Community Support
Tuesday, January 22, 2013 9:36 AM
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.
kindly solve my issue. Is there any extra configuration required for Claims Based SharePoint 2010 Application to create SSIS package?
- Edited by Kanthavel Sekar Tuesday, January 22, 2013 11:41 AM Edit