bcp: Urgent /S parameter

[Brian Moore]

I have a question regarding running bcp imports to a SQL Server where the
data file to be imported is on the same machine as the NT Server running SQL
Server.

If you run the bcp from a client specifying the /S (server) agrument, is
this not as fast as going over to the actual server and running it from
there? That is, does running it from a client workstation (even with the /S
parameter) make the client do the actual processing, making data move across
the network? If so, how can you make the acutal server do the work while
still running it from the client?

I've written a great tool automating data loads using SQL DMO and want this
to run from a client workstation. Speed is key though. If I have to, I
guess I'll have to run this program from the acutal server.

Thanks ahead of time for the responses.

Brian Moore
M.C.S.D.

[Neil Pike]

Brian,

If you run BCP from the client then all files etc. are accessed across the
network.

> If you run the bcp from a client specifying the /S (server) agrument, is
> this not as fast as going over to the actual server and running it from
> there? That is, does running it from a client workstation (even with the /S
> parameter) make the client do the actual processing, making data move across
> the network? If so, how can you make the acutal server do the work while
> still running it from the client?

Neil Pike MVP/MCSE
Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)