title: How to get filename with timestamp in ssis
body: <p>I have an input file which has to loaded daily to my table. I receive files in the following format sample sample_20120518_160754.CSV. Time stamps may vary, it is not current time stamp </p>
  
  <p>I have used expression to get the filename along with date, but how can i get timestamp of the file.  </p>
  
  <p>This was the expression i have used to get the filealong with date.  </p>
  
  <pre><code>"sample_" + RIGHT("0" + (DT_STR,4,1252)DATEPART("yyyy", (DT_DATE)@[User::p_varAsOfDate]), 4) + RIGHT("0" + (DT_STR, 2, 1252)DATEPART("dd", (DT_DATE)@[User::p_varAsOfDate]), 2) + (DT_STR, 2, 1252)DATEPART("mm", (DT_DATE)@[User::p_varAsOfDate]) +"_"  +".CSV"  
  </code></pre>
  
  <p>this expression yeilds result   </p>
  
  <p>sample_2012145_.CSV  now i want time stamp of the file also.</p>