stored proc and filesystem -- help

• mshiva

  Old Hand

  Points: 344

  More actions

  October 16, 2003 at 1:58 am

  #82803

  hi

  i am having a stored proc that manipulates nearly 2.5 million records and i want to write them to a text file. now i am passing these records to a component and writing them to the text file. Can i write a text file from a stored procedure?

  any help is appreciated

  shiva

• JulieW

  Say Hey Kid

  Points: 680

  More actions

  October 16, 2003 at 3:12 am

  #478404

  Hello,

  If you are writing to a text file based upon a SP, why not use DTS, as that can write to a text file automatically.

  Incidently if your writing all of the records to text there are very few editors that can open a text file of that size.

  J