Error: Invalid Hyperlink value in the data being updated.

May 20, 2013 at 1:03 PM
I am using SSDT and running a package locally connecting to my DEV DB server.
I am trying to update SharePoint List Destination and insert into the same list from OLEBD Source which is running a SQL command selecting all the columns.
For both insert and update I am getting error "Error: Error on row ID="1": 0x81020020 - Invalid Hyperlink value in the data being updated."

Detailed error for Insert:
Error: Error on row ID="1": 0x81020020 - Invalid Hyperlink value in the data being updated.
Error: Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.PipelineProcessException: Errors detected in this component - see SSIS Errors
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component XXXXX failed with error code 0x80131500 while processing input "Component Input" (276). 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.

Detailed error for Update:
Error: Error on row ID="1": 0x81020020 - Invalid Hyperlink value in the data being updated. (SP ID=7868)
Error: Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.PipelineProcessException: Errors detected in this component - see SSIS Errors
at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component XXXX failed with error code 0x80131500 while processing input "Component Input" (676). 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.

I have tried to process a single row by changing the SQL command in the Source but it is throwing the same error.
I have analyzed the data and made sure that 1 row does not contain any invalid hyperlink in it.

Please help.

Thanks
Soumyadeb