OLE DB connection problem with AS400

[Mohamed ElSheikh]

Hi,
I created an OLE DB connection from SSIS to AS400 and connection test successful.
The connection is of type (Native OLE DB\IBM DB2 UDB for iSeriesIBMDA400 OLE DB Provider)
But when I use it in an OLE DB Source, it throws a runtime exception with error codes 0xC0202009, 0xC0047038 and 0xC0047039.

The PrimeOutput method on component "OLE DB Source" (109) returned error code 0xC0202009. 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.
Thread "SourceThread0" has exited with error code 0xC0047038 and error code 0xC0047039.

==========
ERROR DETAILS
===========
Error: 0xC0047038 at connection test, DTS.Pipeline: The PrimeOutput method on component "OLE DB Source" (109) returned error code 0xC0202009. 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.
Error: 0xC0047021 at connection test, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.
Error: 0xC0047039 at connection test, DTS.Pipeline: 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.
Error: 0xC0047021 at connection test, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

Could anyone help please.

[Bob Barrows]

Post by Mohamed ElSheikh
Hi,
I created an OLE DB connection from SSIS to AS400 and connection test successful.
The connection is of type (Native OLE DB\IBM DB2 UDB for
iSeriesIBMDA400 OLE DB Provider)
But when I use it in an OLE DB Source, it throws a runtime exception
with error codes 0xC0202009, 0xC0047038 and 0xC0047039.
The PrimeOutput method on component "OLE DB Source" (109) returned
error code 0xC0202009. The component returned a failure code when
the pipeline engine called PrimeOutput(). The meaning of the failure
code is defined by the component,

Having struggled with this several times in the past few years I can really
emphasize. The error is very generic and I have had to use as many different
solutions for it as the number of times I've encountered it. A starting
point is this list of search results:
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=IBM+0xC0202009