none
SSIS Error Code DTS_E_THREADFAILED and DTS_E_PRIMEOUTPUTFAILED.

    Question

  • Hi

     

    I have a SSIS package which extracts data from a progress database (Version 10) and writes to a SQL table. I use a data reader to extract the progress data from the source however I have a problem.

     

    When I try to extract one extra field (a text field of 2000 characters) into my SSIS routines I get the following error message. I have supressed this before on other routines using the fetch array size on the odbc connection however I cant resolve the problem with this field.

     

    I know progress is a tricky data source however does anyone have any thoughts on whether this is a limitation on the odbc drivers or something which I can handle in SSIS i.e. reduce the input of rows, tweak buffer size? If so does anyone have any suggestions on settings to try - currently they are the default.

     

    The Error Message :-

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

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

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

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

    SSIS Error Code DTS_E_THREADCANCELLED.  Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.  There may be error messages posted before this with more information on why the thread was cancelled. 

    SSIS Error Code DTS_E_THREADCANCELLED.  Thread "WorkThread3" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.  There may be error messages posted before this with more information on why the thread was cancelled. 

    SSIS Error Code DTS_E_THREADCANCELLED.  Thread "WorkThread4" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.  There may be error messages posted before this with more information on why the thread was cancelled. 

    SSIS Error Code DTS_E_THREADCANCELLED.  Thread "WorkThread2" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.  There may be error messages posted before this with more information on why the thread was cancelled. 

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

    SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "RM Job" (1) returned error code 0xC02090F5.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure. 
    The component "RM Job" (1) was unable to process the data. 

    "

     

    Thanks

    Dan.

    Wednesday, May 21, 2008 3:59 PM

Answers

All replies