Friday, February 24, 2012

DTS_E_PRIMEOUTPUTFAILED

I'm attempting to import a dbf file into a SQL server staging table. The following error is being reported:

[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DBF File" (1) returned error code 0x80040E21. 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.

Data provider is Jet 4.0. Is this just a corrupt file? Or does this indicate something else? The package has run successfully on all previous occasions. Thanks in advance.

Please provide the surrounding errors as well.|||

This is the first error in the chain. The others seem to be a result of this error, but for completeness, I will include them here.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0x80040E21. 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.

[DTS.Pipeline] Error: 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.

[DTS.Pipeline] Error: 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.

[DTS.Pipeline] Error: 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.

Thank you for your kind assistance.

|||You might want to read through this to see if anything works for you.

http://adopenstatic.com/faq/80040e21.asp|||Well, the file is definitely corrupt. I'm getting an error when I try to import it to Access.|||

Benda Fenda wrote:

Well, the file is definitely corrupt. I'm getting an error when I try to import it to Access.

Glad you got to that point at least.

No comments:

Post a Comment