RSS

All Project Updates

Discussions

Issue Tracker

Releases

Reviews

Source Code

Wiki & Documentation

RSS

SharePoint List Source and Destination

Released:	Mar 17 2009
Updated:	Mar 19 2009 by kevinidzi
Dev status:	Stable
Rated:	based on 17 ratings (Add your own rating)
Reviewed:	16 reviews
Downloaded:	14120 downloads
Wiki link:	[release:17652]

SharePointListAdaptersReadme.rtf

documentation, 76K, uploaded Feb 11 - 4803 downloads

SharePointListAdaptersSetup.msi

application, 463K, uploaded Mar 19 - 3974 downloads

SharePointListAdaptersSetupForSqlServer2005.msi

application, 463K, uploaded Mar 19 - 3525 downloads

SharePointUtility.dll

application, 83K, uploaded Feb 11 - 1818 downloads

Microsoft Public License (Ms-PL)

This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software.

1. Definitions

The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law.

A "contribution" is the original software, or any additions or changes to the software.

A "contributor" is any person that distributes its contribution under this license.

"Licensed patents" are a contributor's patent claims that read directly on its contribution.

2. Grant of Rights

(A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create.

(B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software.

3. Conditions and Limitations

(A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks.

(B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically.

(C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software.

(D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license.

(E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive 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 with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Note: Currently this adapter works with English (en-US) SharePoint server culture settings only. Feel free to contribute if you want to add more support!

UPDATE - 3/18/2009
1) Hotfix update.

UPDATE - 3/17/2009
1) Fixed support for multi-line text to be retrieved from SharePoint as NTEXT (there was a bug in previous attempt at this)
2) Added ability for user to rename source/destination columns and have the names remain even after refreshing the sharepoint list from the source (to pull in new columns or something)
3) Updated it so that numeric values from SharePoint will come into SSIS as null if they are null, vs being translated to a 0
4) This release will fix an issue with prior release's version # making it a breaking change for SSIS Packages

UPDATE - 2/11/2009:
1) Support wide lists with lots of data in a column.
2) Support multi-row text columns up to 2 bil chars
3) Added Culture to allow proper formatting of numbers/dates on external systems in different languages
4) Changed validation so that if a column is ADDED to sharepoint, it will not cause a validation error, only if a needed column is removed (helps with lists where people are adjusting them after you sync a process to them)
5) Fixed bug in datatyping where the data was being written using the wrong datatype (R8 Issue)

Also - The SharePointUtility.DLL has been added as a separate download to facilitate using it to access SharePoint Lists API without requiring the entire MSI.

Written by Kevin Idzi

Releases

Released | Planned

	SharePoint List Source and Destination Mar 17 2009, Stable
	EzAPI - Package Generation API Dec 30 2008, Stable
	BizTalk to Integation Services Samples Nov 12 2008, Stable
	MERGE Destination Nov 4 2008, Beta
	Spatial Data Flow Components Sep 30 2008
	SQL Server Data Services Source and Destination Sep 24 2008, Stable
	WMI Source Sep 24 2008
	Hello World Task Sep 24 2008
	Dynamic Package Generation Sample Sep 24 2008
	Delimited File Reader Source Sep 24 2008
	Regular Expression Flat File Source Sep 24 2008
	XML Destination Sep 24 2008

There are no planned releases for this project.

Reviews for this release

This adapter was a tremendous help to the project and is part of a robust system integration.
by pjacob on Wed at 11: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 at 4:22 PM

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

Deffinately the skeleton key you need
by salemboot on Nov 3 at 10: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 at 10: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 at 2: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 at 10: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 at 8: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 at 2:32 PM

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

couldn't live without it
by howarddierking on Apr 15 at 11:15 PM

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

This is very nice component.
by Aviw on Apr 8 at 3:46 PM

This is an outstanding product for managing Sharepoint lists using SSIS!
by Mark123 on Mar 20 at 6: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 at 2: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 at 7:11 AM

Microsoft SQL Server Community Samples: Integration Services

Recommended Download

Other Available Downloads

Release Notes

SharePoint List Source and Destination Sample

Releases

Rate this release

Delete SharePoint List Source and Destination