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?
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.)
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.