If you batch your delete and output it into the destination table, you don't have to set identity_insert on. At least thats what I'm seeing. I did...