In the previous example, we knew that the injury didn't exist in the destination table, but that is not the only possible error when trying to update a table. Let's refine our transformation a bit, as follows:
- Right-click on the Update step and select Error Handling....
- In the window that shows up, look for the Error descriptions fieldname textbox, and fill it in with the text error_description.
- Close the window.
- Run the transformation again. This time, no row is updated, as we already updated the comment the first time we ran the transformation.
- If you look at the Logging window, you will see the details of the rejected row, including a new field with the description of the error that caused the rejection:
... - rejected ...