mberman (3/19/2013)

---

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!