title: Import most recent csv file to sql server in ssis
body: <p>i have an folder, in which i receive .csv files for every half hour with time stamps. Now, i need to take the latest file from the available files and import it into sql server.</p>
  
  <p>For Example</p>
  
  <p>in my source folder, i have </p>
  
  <p>test_01112012_120122.csv<br>
  test_01112012_123022.csv<br>
  test_01112012_123555.csv</p>
  
  <p>now i need to fetch the latest file and import that file into sql server with the help of SSIS. </p>
  
  <p>Thanks<br>
  satish</p>