bcp message

  • zishanz

    SSCommitted

    Points: 1792

    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.

  • Andy Warren

    SSC Guru

    Points: 119676

    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

    http://www.sqlservercentral.com/columnists/awarren/

  • zishanz

    SSCommitted

    Points: 1792

    Hi, it works great for me! Thank you very very much!!!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply