DSXchange

I am trying to capture rejects while upserting records into Sybase. I am using the "insert new rows or update existing rows option."

When a record is rejected the REJECTED, REJECTEDCODE are set to 0 in the transformer reject output link. Has anybody else experienced this issue. I appreciate any inputs.

Its a Parallel job with BASIC transformer and SybaseOC stage.

What link are you providing in the linkname.REJECTED. That linkname should be the one going into the database.

DSguru2B wrote:What link are you providing in the linkname.REJECTED. That linkname should be the one going into the database.

Yes, I am using the linkname that is going to the Sybase OC stage.