How to store error occurring data

[Anonymous]

Hi,

     Now am reading .xlsx file and stored to the table, but some rows are occurring the error and data will be stored on the target table, for example the total number of rows is 110, but inside a table is only 105 rows are stored on tDBOutput1 and I want to store failed records also in a separate table on tDBOutput2.

Please, anyone, help me.

[Anonymous]

Hi
There is an reject flow on tDBOutput, the problematical records will be captured and stored in reject flow during the execution. eg:
...tDBOutput1--reject--tlogRow(or tDBOutput2)
Note that the reject flow is only available when 'Die on error' box and 'Extend insert' (Batch insert) box is unchecked.

Regards
Shong