Sharepoint_Online_ConnectorsV2.1

Rating: No reviews yet
Downloads: 9
Change Set: 30914
Released: Mar 3, 2014
Updated: Mar 3, 2014 by dilkush
Dev status: Stable Help Icon

Recommended Download

Application Sharepoint_Online_ConnectorsV2.1
application, 35K, uploaded Mar 3, 2014 - 9 downloads

Release Notes

(Delete Function will be added in next release)

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

No reviews yet for this release.