Facing Problem while executing bcp with stored Procedure having parameters

• milandas56

  Grasshopper

  Points: 14

  More actions

  September 7, 2012 at 1:58 am

  #261288

  Hi,

  I'm getting a error: BCP host file must contain atleast one column

  Below is my Code:

  bcp " exec [DatabaseName].dbo.GetBcpOutput1 'csv_test','select top 10 * from csv_test'" queryout D:\Book5.csv -S MAT-DB02\DO -T -c -t,

  Can anybody help me out?:-)

• milandas56

  Grasshopper

  Points: 14

  More actions

  September 7, 2012 at 6:05 am

  #1535023

  This is not what i meant

  i have stored procedure whose functionality is to insert the column headers as the first row and the parameters i have passed is the TableName&Query

  so i have to execute this SP using BCP