Can I get a DTS package to run in a loop until a table is empty?
Posted on 2005-04-07
I've been weening myself off Access though it is an easy tool to create stuff like this in.
I'd like to do this with a scheduled DTS package, here is how it is executing at the moment:
3 queries execute one after another-
1. Drop table DeleteDups
2. Make table query creates a table of ID numbers I would like to delete from another table
3. Delete query runs and deletes those ID numbers
I would like this to loop until the DeleteDups table has 0 rows (no more IDs to delete).
DeleteDups has only one column: MaxOfID
What would be the best way to do this?