DTS Versus Linked Servers

Hello Everyone,
Is it usually faster to transfer data using DTS or over a Linked Server?
Thank you.
ScottIt all depends on what are you transferring. In my experience:
-. For small number of records and ad-hoc transfers, linked server does the
trick
-. For import jobs with transformation, extraction and load, that need to be
performed regularly, DTS may be your candidate
-. For massive amount of data to be transferrend to single tables, BCP out
to text files and BCP in to the target server is faster than linked server o
r
DTS.
"Scott Yu" wrote:

> Hello Everyone,
> Is it usually faster to transfer data using DTS or over a Linked Server?
> Thank you.
> Scott