I am using tOracleInput to input data to database table. From time to time, I got For input string: error because of the data type difference. However, the program still moved on to the next records and skipped the record. It is hard for me to identify which records are missed. Is there a way to output the failed records to a file, so I can re-process it later. I was trying the On Component Error, but no luck. Anyone has any idea how to output the skipped or failed records? Thanks, email3888
Hi Sabrina, Happy New Year! I just came back from holiday. Sorry for the late reply. I am using Oracle database. In the tOracleOutput component, I unchecked Die on error. But, I cannot see the Rejects under the Row.
