Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.

Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components

Linq: The Component has been written using Linq and shows how elements such as the metadata and columns can be combined for data retrieval..

Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Connection Manager to store a username / password

Currently this adapter works with English (en-US) SharePoint server culture settings only.

NOTE: PLEASE do not post issues you're having in the comments, try the discussions area or issue tracker for answers first. Since SharePoint is used as-is, there are some funny things it can do which others may be able to assist with which are unrelated to the tool itself. Plus, comments are not made for questions - can't have a discussion or respond as easily to them.

Reviews for this release

Works really well. It helped me see the facility of SharePoint lists in a broader scope, and now we're using this capability for light MDM.
by robsch
on Oct 13, 2009 at 9:55 PM

It's nice, work with VS2013 and SSIS2014, but have a problem with Claim Authentication, I use FBA and Windows. Work only with Windows.
by RodrigoCMz
on Jul 26 at 10:08 PM

Would rate excellent if it supported SSIS 2013. Working very well though for my needs for a minor data maintenance utility using SharePoint as the UI for a small dataset on a SQL backend.
by dander301
on Jan 20 at 2:52 PM

Great work! Exactly what my current project was looking for. Even though it is a bit old, unfortunately. I had SSDT-BI 2012 installed on my comp and it worked swell! But on the project server we had SSDT-BI 2013 and it did not show up. And the instructions does not fit 2013 version because the "Chose Toolbox Items" Window does not have a "SSIS Data Flow Items tab" where I can add the two components (source and destination adapter for from - and to SharePoint). I will try to get the project to put the component on an older server, but that is a ticking bomb of course. Maybe some other genious could look at it and see what is to do about adding them to "common" list. Kudos to you devs out there who shares your solutions.
by jb300
on Oct 10, 2014 at 4:13 PM

This was such a time saver for us. We've been forcing our business users to create CSV feed files (manual process) and submit those to us for processing. This will make them very happy once we automate the pull from SharePoint lists. One feature request: As of today, the configuration items (like the Site URL, List Name etc.) need to be hardcoded at design time and can't be changed via Project Parameters (we're using SSIS 2012). once this feature gets added, this component will be worthy of no less than 5 stars! Still, very well done!!
by MuqadderIqbal
on Jul 29, 2014 at 12:21 AM

This is an amazing tool for getting SharePoint List data in to SQL Server. I'm using it with SharePoint 2010 and SQL 2012 and it has worked flawlessly; it was extremely easy to set up and I've been able to automate so much data management with this!
by bparker
on Aug 28, 2013 at 4:34 PM

Must have if you have SharePoint data sources.
by ZoltanHorvath
on Jul 24, 2013 at 10:55 AM

Thanks!
I have even refered to this page in my blog:
http://afsawaf.blogspot.com/2013/06/options-for-accessing-sharepoint-lists.html
by afsawaf
on Jun 12, 2013 at 9:41 AM

Why has this not been updated to work with SQL Server Data Tools and SQL Server 2012? All of the fixes I have been able to find involve tabs that don't exist in the Tool any more. This is totally inadequate. I told my people that there was a Sharepoint solution and now I have to walk that back because it doesn't even install correctly.
by RonSteinhauser
on May 15, 2013 at 4:30 PM

If you get an error installing your package on your deployment server then check that this file exists
C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\SharePointListAdapters.dll
For me it failed to install so I created an Administrator command prompt and re-ran the installation and this time it worked.
David Bridge
www.davidbridgetechnology.com
http://davidbridge.wordpress.com
by DavidBridge
on Mar 6, 2013 at 10:46 AM

This produces an error when a SharePoint 2010 library has more than 10,000 items even though the view selected is filtered down to less than 5,000 items. Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unspecified SharePoint Error. A possible reason might be you are trying to retrieve to many items at a time (Batch Size). I have upped the batch size to no avail.
by JSJatFIS
on Mar 14, 2012 at 7:22 PM

Getting an error using SQL Server 2008 R2 Developer Edition:
Description: System.IO.FileNotFoundException: Could not load file or assembly 'SharePointUtility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=f4b3011e1ece9d47' or one of its dependencies. The system cannot find the file specified. File name: 'SharePointUtility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=f4b3011e1ece9d47'
by ddorlando
on Aug 4, 2011 at 6:40 PM

This project saved me a lot of time and grief!!!! I've been using it for almost two years now and it's worked great!
by binarydivision
on May 19, 2011 at 4:20 PM

Outstanding! I was on the SQL Server and SharePoint product groups at Microsoft and consistently lobbied for this feature to be built into those products. Kudos on delivering a functional solution!
by MalaysianMenace
on Feb 4, 2011 at 10:50 PM

This product proven invaluable when it comes to reporting and analyzing SharePoint list items. We've recently had issues with the Beta's custom credential (works for accessing and refreshing columns in design but fails when package is run) but plan on finding a workaround.
by btmicrolink
on Dec 30, 2010 at 1:44 PM

Is there a way to use a expression in the SiteURL? It would be nice to use a variable.
by Robbertos
on Jun 11, 2010 at 8:17 AM

I am using the latest version and it works great 90% of the time. It failed however on a list with a lot of columns - problem is described here.
http://www.sharepointsteve.com/2010/06/field-limit-for-sharepoint-source-and-destinations-for-ssis/
by sharepointsteve
on Jun 10, 2010 at 3:06 PM

Error on row ID="1": 0x81020016 - List item referred to in the request does not exist.
Solution:
Install SP2 2.0 Version on WSS.I didn't get above issue.
by kaleppu
on Jun 9, 2010 at 2:46 PM

very helpful. Please please provide some demo code samples if possibles.
by jazzyg
on May 25, 2010 at 7:49 PM

It solved a lot of problems in a easy way!! 5 stars!
by comick
on May 6, 2010 at 6:53 AM

Excellent Tool.
Quick Question, I am trying to insert large number of records (around 13000). I have set up excel source (Which has all the 13000 records) and Sharepoint Destination. When I execute the job, It only shows 1693 records being created. Is there a limitation on number of records it can write to a list.
by vsrcmurthy
on Apr 29, 2010 at 4:05 PM

Very helpful tool. Well executed. Date/Time insert bug still a hassle.
by danpatdav
on Mar 30, 2010 at 1:59 PM

with the joint use of Infopath 2007, SQL 2008 and workflow.
by georgepinheiro
on Mar 1, 2010 at 1:22 PM

Can anyone provides an example to load into a hyperlink list field? I used an derived column but failed on the sharepoint list destination. and the expression on the derived column was "http://somelink.com" + ", " + "my title"
by smackdown
on Feb 24, 2010 at 6:43 PM

Great tool in SSIS toolbox; Couldn't able to get Sharepoint List data through secured http; but worked with alternate access mapping to the site.. which need the maintanence and coordination with team for follow up on AAM changes..does this gets updated to even make use of https sharepoint lists?
by lsupailla
on Jan 21, 2010 at 5:30 PM

SQL Server 2005 version does not work
by ansonee
on Jan 21, 2010 at 2:55 PM

This adapter was a tremendous help to the project and is part of a robust system integration.
by pjacob
on Nov 18, 2009 at 10:30 PM

This is a great addition to my SSIS toolbox, but it's a little awkward in some respects. For example, I discovered that when I tried to insert datetime columns to lists, I would lose the time value (i.e. mm/dd/yyyy 12:00 AM). I was able to correct this by converting the datetime to a string (DT_STR) in the dataflow before loading. I'm sure this will be fixed in future releases. Good work!
by CharlesAsbornsen
on Nov 10, 2009 at 3:22 PM

Can't get the SQL Server 2005 version to work.
by anyam_99
on Nov 9, 2009 at 7:50 PM

Deffinately the skeleton key you need
by salemboot
on Nov 3, 2009 at 9:01 PM

I cannot add none of those components from the toolbox. After dragging it to the working pane, I receive an error that "...This component could not be added. Please verify it's properly installed". I'm using SQL Server 2005, so picked up corresponding .msi for it. Please help!
by mikelalala
on Jul 27, 2009 at 1:44 PM

Great component. Connected it to internal site list in 5 minutes! One question, how can I connect this to a password protected site? Can I provide username/password somewhere or does the ssis account need access?
by thijsnijhuis
on Jul 20, 2009 at 9:22 AM

These Sharepoint Source/Destination transforms are great and long overdue. Accessing Sharepoint from SSIS is now MUCH simpler!
by duke_newcom
on May 13, 2009 at 7:27 PM

This source and target adapters for SP are a fantastic set of SSIS components. It would be nice if the source component would deal with special SPField types so that using the derived column object wouldn't be necessary. However, this is minor and is the only critical input I can provide. Other than that, these components rock.
by ewilansky
on May 8, 2009 at 1:32 PM

great work! takes care of many hassles
by jammyg
on May 4, 2009 at 8:30 AM

a must have in your SSIS toolbox
by djeepy1
on Apr 11, 2009 at 6:09 AM

This is an outstanding product for managing Sharepoint lists using SSIS!
by Mark123
on Mar 20, 2009 at 5:33 PM

This is great, there's some minor issues with running side by side, but nothing major, a simple recompilation fixes it.
WISH: That the adapter could create a sharepoint list if it didn't already exist!
by jashwood
on Mar 10, 2009 at 1:10 AM

Hello,
Greate idea ill have to say. i have installed the 2005 installation, flow up the orders step by step, but in the end when i tried to add it to the ssis control flow items, i didnt find it in the list.
did someone have any suggestions why i dont see it there?
i am using ssis 2005 with framework 3.5 sp1.
Thanks,
Ronen Amsalem
by amsalemronen
on Mar 9, 2009 at 6:11 AM