Sharepoint_Online_Connector_V2.4

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 2141
Change Set: 35463
Released: Aug 14, 2015
Updated: Oct 7, 2015 by dilkush
Dev status: Stable Help Icon

Recommended Download

Application Sharepoint_Online_Connector_V2.4
application, 34K, uploaded Oct 7, 2015 - 2141 downloads

Release Notes

V2.4
Changed validation rules for server name. Now it should support custom DNS names.

V2.3.5
Removed validation for user name where it was accepting user name with only ".com"

V2.3.1
Added support for column with string array type. (For source only)

V2.3
Added support for delete operation.
just map ID columns and choose operation type as "Delete"
Any other Operation Type will be taken as Insert\Update
MultiUser type will be taken as User field and single user will be added, still figuring out how to add multi user field (whatever available on internet not helping :( )

V2.2
Fixed issue that fields were coming NULL for source
Added Support for Multi user field in Source
Added Support for URL Type
Fixed issue with updating User type.
(DateTime update works fine, in case if it fails for you provide error message)

V2.1 (Now Fixed)
Added Support for read only columns
(No hidden columns, if anyone needs then as well let me know)

V2.0
Now it will update data if ID value is already present in sharepoint list, If ID is not present it will add new row
Fixed issue where it was not pulling data for field with space in name of field.


V1.4
Added ICON file as VS 2012 was giving bull stream error after update to CU3.

V1.3
Added support for user name with @<company name>.com


V1.2

Using Friendly names instead of Internal names so that users can understand what column they are dealing with.
Report Issues if you find that it is not working as expected.

V1.0

Source:
Handles all basic data types
Number, String, DateTime

Destination:
Handles all basic data types
Will add User Type if provided user exists else it will error out

Issue:
Uses internal name for mapping.

Prerequisite:
It will need following dlls to be present:
Microsoft.SharePoint.Client.dll
Microsoft.SharePoint.Client.Runtime.dll

Microsoft.SQLServer.ManagedDTS.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.PipelineHost.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlEnum.dll

How to use this Task:
1) Copy dll in "C:\Program Files (x86)\Microsoft SQL Server\110\DTS\PipelineComponents"
2) Register component in gac using
gacutil /if "DLL name with complete path"

(for using gacutil open visual studio command prompt as administrator)

Reviews for this release

     
Great extension! I have been looking for a way to connect to SPO for a long time. Thanks a lot for this! Noticed a few errors in the text of properties etc. but these are only cosmetic.
by bmcomp on Jan 29, 2016 at 12:51 PM