output records to a flat file inside SQL Server

• btkaruna

  Mr or Mrs. 500

  Points: 506

  More actions

  August 1, 2001 at 5:38 am

  #63752

  hi,

  I am using sel server6.5.I have to output

  records into a flat file on update trigger.

  without using xp_cmdshell is there a way to

  output records into flatfile

  thanks in advance

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 1, 2001 at 7:56 am

  #417359

  Its basically the same as generating xml manually (not using the ADO option to persist as XML). Another option would be to apply a transform to the XML to generate the text - a cool solution.

  Andy

  Andy
  Connect with me on LinkedIn