Can't Delete Records from WSS 3.0 Document Lib using SQL 2005 SSIS

Discussion in 'microsoft.public.sqlserver.dts' started by HaroldH, Jun 10, 2010.

  1. HaroldH

    HaroldH Guest

    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.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(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.
     
    HaroldH, Jun 10, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.