title: Multi File Connection Manager in SSIS
body: <p>i am working on a scenerio where i need to load 3 csv files into my table. For this purpose am using 3 flat file connection managers.  </p>
  
  <p>Now instead of using 3 flat file connection managers i need to use only one connection Manager for all the 3 files.  </p>
  
  <p>I came to know we can use Multi File Connection Manger for this purpose, but this works only when the files have same columns.  </p>
  
  <p><strong>1. My first csv has id, Rate, Amount,Total_Amt  columns<br>
   2. Second Csv File has id, Rate, Amount, Total_Amt, Date, Debt columns<br>
   3. Third CSV File has id, Rate, Amount, Total_Amt, loss, Gain columns</strong>  </p>
  
  <p>how can i use multi file connection manager for this approach.</p>