SSIS - Maintenance Cleanup Task

• EjSQLme

  SSCrazy

  Points: 2172

  More actions

  December 2, 2010 at 7:34 am

  #142763

  HI,

  Is there any way to have a file name 'like' to be deleted using the Maintenance Cleanup Task. The issue that I'm having is that, I have a two file names with the same file extension with *.rar, so I want to pick and delete only one of the file name.

  For example, I have a file name called: FileName_Backup_20101202.rar and FileName_Log_Backup_20101202.rar

  Everyday a new file name with date stamp at the end is created, so I want delete file names that start with FileName_Log_Backup every 3 days and FileName_Backup every 7 days. I can't use the "Search folder and delete files based on an extension" option because they have the same file name extension. How can I get this using Maintenance Clean Task or is there other way to do this?

  Thanks,

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  December 2, 2010 at 7:45 am

  #1257896

  I don't think that's possible with the Maintenance Cleanup Task, since it's done on extension only. Have you tried the File System task?

  John

• EjSQLme

  SSCrazy

  Points: 2172

  More actions

  December 2, 2010 at 11:25 am

  #1258021

  I just looked at it, but not sure how? How would the file system task help me?

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  December 3, 2010 at 1:33 am

  #1258237

  Well, it has a Delete File operation. And you can dynamically define the connection, so you should be able to delete any file pattern you choose.

  John