title: how to load extracted file name into sql server table in SSIS
body: <p>i have 3 csv files in a folder which contains <b>eid, ename, country</b> fields, and my 5 csv files names are test1_20120116_034512, test1_20120116_035512,test1_20120116_035812 etc.. my requirement is I want to take lastest file based on timne stamp and modified date, which i have done. Now i want to import the extracted file name into destination table..</p>
  
  <p>my destination tables contains fields like,</p>
  
  <p><b>filepath, filename, eid, ename, country</b></p>
  
  <p>I have posted regarding this before in the same site i got an answer for extracting filename, now i want to load the extracted FileName into destination table </p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/8831060/import-most-recent-csv-file-to-sql-server-in-ssis">Import most recent csv file to sql server in ssis</a></li>
  </ul>
  
  <p>my destination tables should have output as </p>
  
  <p><b> C:/source   test1_20120116_035812   1234   tester   USA</b></p>