Post reply

using bcp to create an xml format file

  • November 12, 2008 at 3:47 am

    #124298

    hi all,

    i'm creating this bcp command line to create a format file

    bcp "SELECT id_s, date, log_type, query, user, Sito FROM Log" format nul -n -x -f "log_format.xml" -S .\SQLEXPRESS -T -e "errors.err"'

    but the result is the error:

    "An error occurred while processing the command line"

    what is wrong about my command?

  • November 12, 2008 at 7:10 am

    #897494

    ok, sorry

    the format fle has no input query but only a table like this MyDB.dbo.MyTable

    thanks

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

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