AS400(ODBC Read) --> Transformer --> ODBC(SQL Server)

[prasad111]

Hi,

Job Design

Code: Select all

 ODBC[AS 400] --> Transfomer --> ODBC[SQL Server]
Error: For every column I get the error
ODBC_AS400: When checking operator: The modify operator has a binding for the non-existent output field "COL_1". 
and the job aborts

When I run the same job with DRS Stage it runs without any error.. but it consumes lot of memory and crashes the server, and the job has to process [~45,000,000 rows]
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
31253 bxzzabc 25 0 2944M 2.8G 15664 R 48.1 24.7 3236m 1 sequential APT_CombinedOperatorController

Also no success with RCP enable or disabled.

Could anyone please suggest how to resolve the error with respect to the ODBC stage.

Thanks
Prasad

[prasad111]

We could not use ODBC stage for reading the AS 400 [IBM mentioned they don't officially support the older version of AS400]

Workaround - use server job with ODBC stage for reading from AS400