Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 From sharepoint list 2007 to sql server

Author  Topic 

nkpriya
Starting Member

34 Posts

Posted - 2011-12-06 : 18:28:07
Is there anyway to pull multiple sharepoint 2007 lists to sql server database? I need to join several lists and create a report in ssrs. Currently I created linked tables from sharepoint to MS Access and then updating records to sql server using dtsx packages.

I know that we can pull sharepoint list to sql report direcly. But I need to pull multiple lists and then join, then create sql report based on multiple sharepoint lists. Please advise. Thanks
   

- Advertisement -