I want to delete all files in a given folder that are older than 3 days from today's date.
I tried using a "Foreach Loop container"ÃÂ with aÃÂ "File System" task inside it but found I couldn't access any file properties such as the file creationÃÂ date. Am I using the wrong task forÃÂ this job?
P.S. History of the problem:
I used the sql 2005 Database maintenance program to setup our database backup jobs. One day I noticed that the free space on the drive where we keep the dumps had grown small. I foundÃÂ that we had at least 4 weeks of dumps in there, not the 3 days I wanted to keep!ÃÂ I lookedÃÂ but could not find the "delete file" optionÃÂ in the SSIS package generated by the Database Maintenance Wizard. No wonder the files were piling up.
View Complete Post