SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 3 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

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

Your Answer


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.