• Thank you for your replies. The information was right on.

    I created a scratch table in the database (orders_del) that is just being used to hold the order#'s to be deleted. (I do a truncate on the table first thing.)

    Then the Execute SQL Command Taks does the delete:

    delete FROM dbo.orders WHERE exists

    (SELECT * FROM dbo.orders_del AS tmp

    WHERE tmp.cono = dbo.orders.cono

    AND tmp.orderno = dbo.orders.orderno

    AND tmp.ordersuf = dbo.orders.ordersuf)

    This reduced the time from 3 hours to 11 minutes!