Home Forums Data Warehousing Integration Services How to Check whether the filename is todays file or not(filename like CLM_2014050). RE: How to Check whether the filename is todays file or not(filename like CLM_2014050).

  • April 5, 2014 at 6:11 am

    #1703483

    naresh0407 (4/5/2014)

    Hi All,

    I have file name like this CLM_20140504.I will get file everyday..I just need to check whether file is today's file and then process it.Please let me know how we can do this.

    CLM will be common and date should be today's date.tomorrow file name will be CLM_20140604.I need to compare current date with filename date i.e 20140504.

    Thanks

    The standard way of doing this is to archive the file to a different folder after processing it.

    So your import (or whatever) just processes what is in the 'infiles' folder, regardless of its name.

    One of the problems with your proposed method is what to do if the server is down for a day - you have to mess about forcing yesterday's file to be processed.

    Another problem you will get is that the number of files in the folder builds up over time and you'll never be sure that all of them have been processed.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.