asked
SSIS 2005 data load error
Hi All, When I'm loading data from Progress database to OLEDB destintation, i'm having the error: > Error: 0xC02090F5 at XXXX -> > Inventory_Transactions_Detail_2nd, mfg > 6 [12737]: The component "mfg 6" > (12737) was unable to process the > data. > > Error: 0xC0047038 at XXXX -> > Inventory_Transactions_Detail_2nd, > DTS.Pipeline: SSIS Error Code > DTS_E_PRIMEOUTPUTFAILED. The > PrimeOutput method on component "mfg > 6" (12737) 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. > > Error: 0xC0047021 at XXXX -> > Inventory_Transactions_Detail_2nd, > DTS.Pipeline: 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. > > Error: 0xC0047039 at XXXX -> > Inventory_Transactions_Detail_2nd, > DTS.Pipeline: 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. > > Error: 0xC0047021 at XXXX -> > Inventory_Transactions_Detail_2nd, > DTS.Pipeline: 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. Can anyone help me? :)
As the error states, the component `mfg 6` in `Inventory_Transactions_Detail_2nd` is experiencing an error. I suggest you look at that section of your SSIS package. Is there some sort of invalid data running though it that could cause the problem? A quick google for `SSIS Error Code DTS_E_PRIMEOUTPUTFAILED` shows that it could be a meta data problem, that a refresh of the data connection could resolve it.
