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:56 am

    #1703488

    Thanks for the reply..Just need to validate the filename CLM_20140504..Could you please let me know how can we validate.Today date is 20140504 so the CLM_20140504 is valid file.

    File name should be with today's date.

    If the file name is CLM_20140404 then this is yesterday's file so not valid.So we cannot process yesterday's file today since date in the file 20140404.