Writing result of a stored procedure to a csv file

• namrata.dhanawade-1143388

  Ten Centuries

  Points: 1269

  More actions

  August 13, 2010 at 3:39 am

  #239021

  Hi,

  I have a Stored procedure that returns results.

  I need to write the result to a csv file using a scheduled job.

  How do I go about it?

  Thanks

  Nam

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  August 13, 2010 at 7:21 am

  #1206610

  Use sqlcmd.exe to execute the query and name the ouput file as .csv. Refer this

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 13, 2010 at 7:27 am

  #1206618

  SSIS (Integration Services) and bcp are designed for this very purpose. You should use one of those.

  John