Since I have worked with Oracle I have removed duplicates using the rowid column. SQL Server has something similar but its an undocumented feature (might be changed without notice).

delete

from ...

Thank you, a good information about how it works. I hoped there would be some way to run it in another mood so that the SSIS would wait to return...

I found out that this statement

select *

from Job_Queue

where JobQueueID not in

(SELECT JobQueueID

from Payment

where JobQueueID is not null)

will get...