• Not sure.  It looks like the lookup query is part of a Transform Data task.  I haven't used that to delete rows, just append rows.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor