Error Handling tab
In the Error Handling tab, you can specify how the step reacts when errors occur, such as malformed records, bad enclosure strings, wrong number of fields, and premature line ends.
Ignore errors?
Select if you want to ignore errors during parsing.
Skip error lines?
Select if you want to skip those lines that contain errors. You can generate an extra file that contains the line numbers where the errors occur. Lines with errors are not skipped. The fields that have parsing errors are empty (null).
Error count field name
Add a field to the output stream rows. This field contains the number of errors on the line.
Error fields field name
Add a field to the output stream rows. This field contains the field names on which an error occurred.
Error fields text field name
Add a field to the output stream rows. This field contains the descriptions of the parsing errors that have occurred.
Warnings file directory
When warnings are generated, they are placed in this directory. The name of that file is <warning dir>/filename.<date_time>.<warning extension>.
Error files directory
When errors occur, they are placed in this directory. The name of the file is <errorfile_dir>/filename.<date_time>.<errorfile_extension>.
Failing line numbers files directory
When a parsing error occurs on a line, the line number is placed in this directory. The name of that file is <errorline dir>/filename.<date_time>.<errorline extension>.
Last updated
Was this helpful?