How to use local format file to bcp local data to remote server -- sql server new users

JohnsunKan
7/23/2006 12:00:00 AM

How to use local format file to bcp local data to remote server?
If I use a local fmt file then system reponse "could not find the driver".
If I use DTS to bcp to a remote server, I only can find the remote server's
driver...
Is it possible to use bcp (local data & fmt file) like that ?
Thanks.

Keith Kratochvil
7/24/2006 9:11:25 AM

It should be ok. All you should need to do is specify the remote server
name (-S) and authentication method.

--
Keith Kratochvil

[quoted text, click to view]

sql server new users : How to use local format file to bcp local data to remote server