output records to a flat file inside SQL Server

  • btkaruna

    SSC-Addicted

    Points: 476

    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: 119676

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply