1
Vote

Update to sharepoint using sharepoint list destination is giving error

description

Hi There,

we are using SSIS to updating records in sharepoint list with help of sharepoint list destination control.
While updating we facing below issue

[SharePoint List Destination] Error: Error on row ID="1": 0x80070005 - Unspecified Error - Check SharePoint Server Logs if possible. (SP ID=2170)
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Update" (251) failed with error code 0x80131501 while processing input "Component Input" (261). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

We tried to changing the batchsize =1, still same error persist.

version of sharepoint list destination
Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination, SharePointListAdapters, Version=1.2012.0.0, Culture=neutral, PublicKeyToken=f4b3011e1ece9d47

Could any one please guide in this regard?

Thanks in Advance
Bhaskara

comments