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. The following table contains options for error handling:
| Option | Description |
|---|---|
| Ignore errors? | Select if you want to ignore errors during parsing. |
| Skip error files? | Select if you want to skip those files that contain errors. You can generate a file that contains a listing of files where the errors occur. Otherwise, files with errors are not skipped, and the files that have parsing errors are empty (null). |
| Error file field name | Specify an error file name if you want to add field names where errors were occurred. |
| File error message field name | Specify an error message field name if you want to add field names where errors occurred in the error file. |
| 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. Otherwise, lines with errors are not skipped, and the fields that have parsing errors are empty (null). |
| Error count fieldname | Specify the field name if you want to add a field containing the number of errors on the line to the output rows. |
| Error fields fieldname | Specify the field name if you want to add a field containing the names of fields where errors occurred to the output rows. |
| Error text fieldname | Specify the field name if you want to add a field containing descriptions of the parsing error occurrences to the output rows. |
| Warning files directory | Specify the location of the directory where warnings are placed if they are generated. The name of the resulting file is <warning dir>/filename.<date_time>.<warning extension>. |
| Error files directory | Specify the location of the directory where errors are placed if they occur. The name of the resulting file is <errorfile_dir>/filename.<date_time>.<errorfile_extension>. |
| Failing line numbers files directory | Specify the location of the directory where parsing errors on a line are placed if they occur. The name of the resulting file is <errorline dir>/filename.<date_time>.<errorline extension>. |