Post reply

Delete DateTime Stamp files in a directory

  • August 6, 2009 at 1:20 am

    #385129

    Hi,

    I am deleting the files in a directory which include datetimestamp. The Date Time Stamp is yyyymmddhhmm, for example file1200908061125.

    Like this daily 2 files ('file1200908061125' in the morning and 'file1200908061128' in the night) are generated.

    How can i delete the files which are one month older using SSIS package?

    I am using the Rafael Salas article published abt how to loop through files.

    I am using SQL Server 2005 SSIS Services on Microsoft XP Operating System

    Thanks

  • August 7, 2009 at 3:05 pm

    #1036308

    So you've configured your For Each loop to iterate through only the files you want to remove? Use the File System task inside your loop to delete the files.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

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