Query Sharepoint Services List
-
Does anyone have information on how to query a Windows SharePoint Services 3.0 list to be able to import the data into a SQL Server table?
A nice how to link would be great. 🙂
-
I know someone and we will try to get you something soon.
-
Giving this a hopeful bump.
-
My co-worker is modify code he wrote to access data from SharePoint to remove proprietary info. Unfortunately, he is also out today so I don't have anything for you yet.
One suggestion I do have, do some research on SharePoint Web Services. I started looking at those a while back but got side tracked with other more critical projects and haven't been able to get back to it yet.
-
And I'll be out tomorrow. I'll leave him a note about the code and see where he is on the changes.
-
I'm not sure if this is what you're looking for - it's targeting RS pulling a sharepoint list into a report.
http://www.mssqltips.com/tip.asp?tip=1323
Since everything is stored in SQL Server (or Express) anyways, more details of what you're really trying to do would be helpful.
Greg E
-
Michael Valentine Jones (4/29/2010)
Does anyone have information on how to query a Windows SharePoint Services 3.0 list to be able to import the data into a SQL Server table?A nice how to link would be great. 🙂
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/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply