Hiya, thanks! I like this approach of using the delete/output as an SSIS Source.

However.

I am using the ADO.NET provider. And it's working fine, except in one particular occurrence: Should I stop the package whilst it's running, I see that rows are appended to the Archive Table, from the output portion -- but they are not deleted on the source.

Is there a way to make it so that they ALL going AND get deleted or rolled back as one batch?

I am concerned that on an occasion someone kills the job, it will duplicate those records the next time it succeeds.

Cheers!

Alex