title: Dynamically made flat file connection - want to take most recent file in the folder using SSIS?
body: <p>I have created one SSIS package that takes .csv file data and insert into SQL table,</p>
  
  <p>But now I want most recently added file in that folder suppose</p>
  
  <p>My flat file connection path is : <code>C:\Temp</code></p>
  
  <p>Now in temp there is my file named <code>MYDATA 2011-09-08.csv</code></p>
  
  <p>now some more files are there like <code>MYDATA 2011-09-15.csv</code> , <code>MYDATA 2011-09-17.csv</code></p>
  
  <p>Now <code>MYDATA 2011-09-17.csv</code> is the most recent by date and i want to pickup this file how can i do this???</p>