apply LIKE to read filename

• girl_bj

  SSCommitted

  Points: 1731

  More actions

  November 20, 2014 at 1:39 am

  #150251

  I have txt file format like this Example_20141120_1800_29.txt

  the format is filename_yyyymmdd_hhmm_ss.txt

  the file to be placed has different time, how to apply the expression in ssis to read the file push to table?

  i able to apply the file with the filename and datetime. but my issue here is i wouldn't know the exact datetime.

  any way to apply LIKE in ssis expression?