AS400(ODBC Read) --> Transformer --> ODBC(SQL Server)
Posted: Tue Sep 29, 2009 3:58 pm
Hi,
Job Design
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
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
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