How to get rejected records by tNetezzaBulkExec

[Anonymous]

I'm loading data to Netezza using tNetezzaBulkExec but it always fails because it reaches the max number of errors.

Is there anyways to capture the rows that error out?

[Anonymous]

Hello,

Are you able to use tNetezzaOutput component to load data to Netezza successfully?

Here is a "Rejects" link from tNetezzaOutput component which allows you to track the data that could not be processed for any reason (wrong type, undefined null value, etc.)

Best regards

Sabrina

[Anonymous]

Thank xdshi for your reply. Unfortunately I don'tt use tNetezzaOutput because it is very, very slow and I have about 63 million records to load.

If that is the only option, I guess I will be forced to split the file and try.

Thank again