Post reply

SSIS - Maintenance Cleanup Task

  • 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,

  • 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

  • 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?

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

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