June 2, 2002 at 7:12 pm
Hi, I execute a bcp command from dos prompt, like this:
bcp pub..tablename -Uxxx -Pxxx -Sservername
out outputdir, -c
It works fine. But my problem is: it is always print some messages returned by sql server, like:
1 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 16
Is there any swith I can set to turn off the message, so it just execute the command, without any returning message.
The reason I am asking this is:
whatever it is returned ( the message ), it gets printed on my browser.
Thanks in advance.
June 2, 2002 at 7:30 pm
You could use redirection to either write the output to a file "bcp >output.txt" or to the null device "bcp > nul". Possibly there is a cleaner method.
Andy
June 3, 2002 at 12:33 pm
Hi, it works great for me! Thank you very very much!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply