Assigning Lookups

After creating a lookup, you need to assign that lookup to the field with problematic data in the Write Exceptions stage of the dataflow.
  1. In Enterprise Designer, open the dataflow that is producing the exception records.
  2. Open the Write Exceptions stage.
  3. 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 and click OK.
  4. Save and rerun the dataflow.