Deleting txt files after some time

• mipo

  Ten Centuries

  Points: 1346

  More actions

  June 17, 2002 at 3:41 pm

  #105489

  Hi

  I am looking for some sample code to delete txt files in DTS using Vb script.

  The files are named like MoneyStatistics_2002_02.txt etc.. These txt files will be periodically extracted onot harddisk. Everytime the DTS package is executed the txt files will be checked against a variable containing number of months and if exceeding the files will be deleted.

  I need some information to check the file name and then delete the file.

  Any ideas?

  mipo

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 17, 2002 at 5:08 pm

  #431040

  Use FileSystem object to do this. It has a deletefile method. For more info and a basic example see MSND Library online at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsmthdeletefile.asp

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)