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 4:28 pm

    #1703544

    naresh0407 (4/5/2014)

    .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.

    Assuming that you have gotten the file name in a variable, then split it (remove the prefix) in an expression to retain the date part. Use an execute sql task to run this code on the sql server

    select convert(varchar(32),getdate(),112)

    and compare the two.

    😎