using bcp to create an xml format file

• Simone Foschi

  Old Hand

  Points: 328

  More actions

  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?

• Simone Foschi

  Old Hand

  Points: 328

  More actions

  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