Thanks for the reply 🙂

I'll try to benchmark the transfer speed in development environment.

Can you all give me some explanation, the drawbacks using linked server(open query) rather than using DTS?

Because according to my friend, he said that using open query is much more faster than DTS.