title: SSIS Loading Data from Multiple Tables
body: <p>I am using SQL Server 2008R2. I have almost 30+ tables in database and now I need to load data from these tables into Data Warehouse. </p>
  
  <p>The problem is that DFT(Data Flow Task) only allow to connect with only one table at time. To connect with other table, you need to have another DFT. Now, to extract data from 30+ tables, It seems that I need to create 30+ DFTs. Moreover! Bulk task only works for files.</p>
  
  <p>So, I have two questions here:</p>
  
  <ol>
  <li><p><strong>How to load data from multiple tables.</strong></p></li>
  <li><p><strong>If I create 30+ DFTs, what impact it will have on Performance.</strong></p></li>
  </ol>
  
  <p>I have seen following links:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/16009503/ssis-multiple-table-loads">SSIS multiple table loads</a></li>
  <li><a href="https://stackoverflow.com/questions/20093490/multiple-tables-data-extraction">https://stackoverflow.com/questions/20093490/multiple-tables-data-extraction</a></li>
  <li><a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/80b80533-cc88-4e50-96d3-bdc9d3cb72dd/ssis-dataflow-task-importing-data-from-multiple-tables-and-sending-then-to-multiple-tables?forum=sqlintegrationservices" rel="nofollow noreferrer">Importing data from Multiple Tables. Social MSDN</a></li>
  </ul>
  
  <p>But wasn't able to get satisfactory answer. Second link says, you may create as many S2D tasks as you can but again a performance trade off. </p>
  
  <p>Help is required. Thank You! </p>