title: fetching data from multiple file and loading it into raw file destination(raw file should be dynamic) in ssis
body: <p>I have a source folder which contains 4 csv files with different no of  columns in each of the file. I need to fetch only 3 columns(metadata same this 3 columns in all the 4 files) from each csv and load the columns inside Raw Destination from all the files avaiable in source folder. And Raw destination Output file name has to be like wht the inputfilename we are fetching + time stamp.</p>
  
  <p>And at next level, i need to fetch this output raw as raw source and insert this records into oledb destination . and the destination table also has to be in dynamic.</p>
  
  <p>for example i have <b>4 csv files called, test1.csv(10 columns). test2.csv(8), test3.csv(6), test4.csv(10) along with time stamps. </b></p>
  
  <p>all this 4 files has columns <b>position_id, asofdate, sumassured</b> in common, now i want to load only these 3 columns to raw destination. <b>If i load test1.csv then my raw destination outputfile name  has to be RW_test1_20120119_222222.RW. similalrly if i load second file its filename as raw destination output.</b>. </p>
  
  <p>Thanks</p>
  
  <p>Satish</p>