Error in bcp command execution on Query Analyzer

• Jorge Olimpia

  SSC Enthusiast

  Points: 133

  More actions

  January 6, 2005 at 11:16 am

  #102338

  Hi,

  I have the following problem:

  I´m trying to execute a bcp command on Query Analyzer, for e.g.:

   

  bcp database..table out c:\file.txt -Sserver -Usa -Pmaster -fc:\format.fmt

   

   

  And the Query Analyzer return the following message error:

   

  Server: Msg 170, Level 15, State 1, Line 1

  Line 1: Incorrect syntax near '.'.

   

  If I try to execute the same command with the bcp.exe, the result is Ok.

   

  Somebody have a idea?

   

  Thanks for all help! 🙂

   

• xyz

  SSCommitted

  Points: 1653

  More actions

  January 6, 2005 at 4:25 pm

  #536311

  you need call xp_cmdshell in QA to run the bcp.

  declare @strCMD varchar(100)

  select @strCMD = 'bcp db..table out ..... '

  exec master..xp_cmdshell @strCMD