SharePoint List Source and Destination

Rating:        Based on 49 ratings
Reviewed:  41 reviews
Downloads: 107214
Change Set: 81524
Released: Oct 17, 2011
Updated: Jan 28, 2013 by kevinidzi
Dev status: Stable Help Icon

Recommended Download

Application SharePointListAdaptersSetup.msi
application, 381K, uploaded Oct 17, 2011 - 60775 downloads

Other Available Downloads

Documentation SharePointListAdaptersReadme.rtf
documentation, 465K, uploaded Aug 3, 2011 - 30095 downloads
Application SharePointListAdaptersSetup_x86.msi
application, 381K, uploaded Oct 17, 2011 - 12800 downloads
Application SharePointListAdaptersSetup-Beta-2012-01-28.msi
application, 400K, uploaded Jan 28, 2013 - 3544 downloads

Release Notes

SharePoint List Source and Destination Sample

This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters.

Use this sample to learn more about:
  • 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
  • Supports x86/x64 systems using SQL 2005 / SQL 2008 / SQL 2012 using WiX Installer
  • 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

     
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 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
     
Extremely useful - saving a lot of coding time.
by ClayFighter on Aug 23, 2010 at 2:19 AM
     
Using the SQL2005 version and it's very nice. Enter the site url & list name, map your columns and data comes out. Lovely :)
by ucuuba on Aug 2, 2010 at 1:59 PM
     
No x64 ver?
by darius2 on Jul 23, 2010 at 11:55 AM
     
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
     
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
     
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
     
couldn't live without it
by howarddierking on Apr 15, 2009 at 10:15 PM
     
a must have in your SSIS toolbox
by djeepy1 on Apr 11, 2009 at 6:09 AM
     
This is very nice component.
by Aviw on Apr 8, 2009 at 2:46 PM
     
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