Who said anything about multiple servers? I would then have to open the code on all different servers (even though they all run on a the same one) just...

I guess I was pretty unclear.

I am currently using SSIS data flow task to select and insert rows from one table to another.

There is a check box to commit after...