bcp error when queryout is "exec stored_proc ..."

• g.firpo

  Old Hand

  Points: 366

  More actions

  February 28, 2002 at 3:19 am

  #158153

  Hi,

  I use bcp with "queryout" and, instead of a query as select ... i call a stored procedure.

  example:

  bcp "exec mydb..my_stored_proc 'par1', 'par2'" queryout outfile.txt -c -t; -Slogin -Ppassword

  I run this command from a dos shell and i get this error:

  SQLState = S1000, NativeError = 0

  Error = [Microsoft][ODBC SQL Server Driver]BCP host-files must contain at least one column

  If i run the same s.p. from Query Analyzer there are no problems.

  Anyone can help me ?

  Thanks

  Gianangelo

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 28, 2002 at 5:14 am

  #424629

  COuld you post some details on the procedure. I have tried several and could not duplicate, nor have I come across this before.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)