Post reply

another bcp output format question

  • January 3, 2007 at 1:36 pm

    #122214

    I am trying to output a file, using bcp, that is PIPE delimited, and it keeps giving me syntax errors. The syntax I am using is:

    exec master..xp_cmdshell 'BCP "select * from ##VENDORS" queryout C:\VENDORS.TXT -c -t \|'

    It seems to be able to deal with it if I use \"|, but then it puts the doublequote before the pipe also.

  • January 3, 2007 at 3:52 pm

    #681090

    how about -t "|"


    * Noel

  • January 3, 2007 at 4:01 pm

    #681093

    I THOUGHT in my many iterations that I had tried that, but when I tried it again, it worked.

    Thanks!

    Kerstin

  • January 3, 2007 at 4:02 pm

    #681094

    np


    * Noel

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

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