datestamp a file

• Wendy Fairbanks

  Grasshopper

  Points: 13

  More actions

  June 13, 2006 at 7:38 am

  #114547

  I have a dts package setup to export date to an excel file. I do not want to drop and recreate the file each time or append to the file. I would like to have a new file for each export. How would you recommend I do this?

  Thanks,

  Wendy

• Yelena Varshal

  SSC-Dedicated

  Points: 34287

  More actions

  June 13, 2006 at 9:27 am

  #643430

  ActiveX script task, FileSystemObject

  Regards,Yelena Varsha

• Wendy Fairbanks

  Grasshopper

  Points: 13

  More actions

  June 13, 2006 at 10:47 am

  #643451

  Thanks it works great!