Thanks for the response Sean.

I did try using SSIS transaction and it takes more than 20 X times to execute the package than it would if I use without SSIS...