Error Handling

Handling errors in a transformation

This Lab introduces the Select values step and error handling to find invalid date values.

• Explicit data conversion using the Select values step

• Defining error handling

Configure the following steps:

CSV File Input

Select values

Text File output

Error handling

1. In the Select Values step, check the Date format: yyy-MM-dd. This is obviously an incorrect format which, the records are captured in the Text file output - Error.

2. Preview the Text file output - Error step.

3. Scroll to the end of the execution pane.

Notice the error fields. These have been configured in the hop.

Error fields

1. Double-click on the red cross.

Error handling - hop

1. Set the format to: MM/dd/yyyy

---