Writing a Query to a file

• jmitas

  Newbie

  Points: 3

  More actions

  October 22, 2015 at 10:37 am

  #312441

  I am trying to write a query to a file with a unique name and pipe "|" delimited. Problem is in 2012 the sp_cmd does not exist and I cant seem to find a solution anywhere that will work. I am currently using the code

  set @filepat = 'C:\Temp\'

  set @filename = 'test.txt'

  set @sqlCommand = 'SQL_CMD -S (local) -E -d SqlAndMe -q "EXEC ExportData" - "' +@filepath + @filename + '" -h-1'

  EXEC master..xp_cmdshell @sqlCommand

  Any help please urgent!

• x

  SSC-Insane

  Points: 23660

  More actions

  October 22, 2015 at 10:57 am

  #1834976

  try "sqlcmd" (without the underscore separating sql and cmd)?