I am working with OLE DB from IBM (iSeries Access V5R3 - I tried all the 3
different provider) and SQL Server 2005.
When I try to get Data from an AS400 Table from an OLE DB Source with SQL
Command (also simple SELECTS) I get the error as listed below. Although in
the Query Builder Window and the Preview Window there is no problem. Also if
I take the whole table there is no problem.

I hope you can give me a hint

best regards
Josef

_________________________________________
Error: 0xc0202009 at Data Flow Task:TEAST [1]: An OLEDB error has occurred.
Error code: 0x80040E00
Error: 0xc0047038 at Data Flow TaskTS.Pipeline: The PrimeOutput method on
component "TEAST" (1) returned error code 0x00AF3AA0.[[The identified
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 will stop execution.]]
Error: 0xc0047021 at Data Flow TaskTS.Pipeline: Thread "SourceThread0" has
exited with error code 0xC0047038.
Error: 0xc0047039 at Data Flow TaskTS.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 Data Flow TaskTS.Pipeline: Thread "WorkThread0" has
exited with error code 0xC0047039.

Hi

Probably not helpfull but I have the exact same problem...



Anyone ?