Output to .txt file from SP

• pkrieg

  Mr or Mrs. 500

  Points: 538

  More actions

  March 19, 2004 at 9:07 pm

  #107582

  I would like to output directly to a .txt file from my SP.

  Can you help me?

  Thanks,

  Phil

• Juergen.Leis@Cellent.DE

  Valued Member

  Points: 74

  More actions

  March 20, 2004 at 12:10 pm

  #499653

  EXEC master.dbo.xp_cmdshell 'ISQL -E -Q"EXEC YourSP ... " -o"YourOutputFile.TXT"'

  
  JL
  

• GregLyon

  SSCommitted

  Points: 1946

  More actions

  March 20, 2004 at 2:29 pm

  #499657

  This website: http://www.users.drew.edu/skass/sql/TextDriver.htm outlines a way to use ODBC text driver to read/write text files. I've been meaning to give it a try but haven't gotten to it yet...

  Anyone else tried this method? Do you like it? Hate it?

  Juergen, let us know if you try it how you like it.