• It will give you the option to choose from 1) Delete rows from the Destination table or 2) Append rows to the Destination table. Click on the small button in the Transform section and you will see these options in the Column mappings. Btw I have seen so many of your basic question here, you seriously need to go through the BOL

    Shas3