Deleting Records on a Target Table

Follow these notes to delete records on a target table.

  1. On the target table, you must have defined a primary key. From Edit Tasks, select the Properties tab, and, under General Options, set Treat Source row as to Delete.

  2. Also on the target table, from the Edit Tasks dialog, choose the Mapping tab. Under Properties, check-off Delete.