using bcp to create an xml format file

  • 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?

  • 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