Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is there a way to do this via code? How so? I simply want to import data from a list in SharePoint 2010 to a SQL 2005 or 2008 server.

I know there are several 3rd party plug-ins that work, but I can't run the jobs from the server automatically as I would have to buy the product.

I want come up with something that I don't have to buy.

Where would I start? Does anyone have code samples of this?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

You could do this without code by using BCS to connect to your SQL table with 2 way data update support, and use a workflow to transfer your sharepoint list to the external list (which would then write to your SQL table via BCS).

share|improve this answer
add comment

http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

Free codeplex Sharepoint List Adapters for SSIS 2008 and SSIS 2005. I use these regularly in SSIS to download lists into SQL Server.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.