Deleting Records on a Target Table
Follow these notes to delete records on a target table.
-
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.
-
Also on the target table, from the Edit Tasks dialog, choose the Mapping tab. Under Properties, check-off Delete.