After creating a lookup, you need to assign that lookup to the field with problematic data
in the Write Exceptions stage of the dataflow.
- In Enterprise Designer, open the dataflow that is producing the exception records.
- Open the Write Exceptions stage.
- In the Lookup name column for the field with problematic data, select the lookup that contains the new, accurate data from the drop-down list.
- Click OK.
- Save and rerun the dataflow.