Re: Bulk Insert Syntax

#1

Can you access the client from the server? I think BULK INSERT is the wrong
tool, since it is a server side data loader, look at BCP or the DST data
pump instead.

GertD (AT) SQLDev (DOT) Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.

"PLJ960" <PLJ960 (AT) discussions (DOT) microsoft.com> wrote

Quote:

My VB.NET application needs to compose and execute bulk insert statements
for
a sql server database. It runs fine on the computer hosting the database
(...FROM c:\filename.txt...) but doesn't work on other machines on the
network.

Can someone please help me with the appropriate syntax. MSDN indicates I
need the path from the server, so I tried adding the computer name prior
to
the c:\filename.txt, but it complains about the syntax.

Thanks so much for your help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Bulk Insert Syntax

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Bulk Insert Syntax - 09-08-2004 , 12:07 AM