Am running in BIDS using the SQL 2005 SSIS sharepoint list source and
destination source to identify the doc lib. Have a test doc lib setup with 2
documents and I want to delete both of them.

In execution the 2 docs are read but then I get the below errors which I am
unable to unravel:

[SharePoint List Destination] Error: Error on row ID="1": 0x81020030 -
Unspecified Error - Check SharePoint Server Logs if possible. (SP ID=1)


[SharePoint List Destination [789]] Error:
Microsoft.Samples.SqlServer.SSIS.SharePointListAda pters.PipelineProcessException:
Errors detected in this component - see SSIS Errors at
Microsoft.Samples.SqlServer.SSIS.SharePointListAda pters.SharePointListDestination.ProcessInput(Int32
inputID, PipelineBuffer buffer) at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentH ost.HostProcessInput(IDTSManagedComponentWrapper90
wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)


Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on
component "SharePoint List Destination" (789) failed with error code
0x80131500. 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.

Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited
with error code 0x80131500. There may be error messages posted before this
with more information on why the thread has exited.

Have scoured the internet looking for a cookbook/how to on deleting from
sharepoint document libraries but have found nothing. Have been able to
delete and modify a regular data list but cannot delete from a doc library.

Thanks for any assistance.