Text File Through Stored Procedure

• dcoggin

  SSC Veteran

  Points: 278

  More actions

  August 9, 2002 at 6:19 am

  #58318

  I need to create a stored procedure which generates a text file. This text file can be empty as it is only being used for a trigger to start another package.

  Does anybody know the syntax that I will need to create this??

  Thanks

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 9, 2002 at 8:14 am

  #434340

  If you just need a marker file, you can do xp_cmdshell 'dir > flag.txt'.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter