Which one does the work ? Both ? Isn't most work done on
the one that pulls data out...?

Can the one that pulls data out cause blocking on the other server ?

/michael V.

DTS is client side so the hard work is done on the box that runs the package
(Transform Data Task)

Pulling data from a server to somewhere else should only be seen on the
source server as a request for data i.e. a SELECT. It will initially ask if
the structure looks like it should but that's about it I think

"Michael Vardinghus" wrote:

It depends as there are different ways to pull the data but
both do some work.

operations. Shared locks aren't compatible with exclusive
locks (IX, SIX and X). You can use sp_who2 on the other
server to identify any spids involved in blocking.

-Sue