title: SSIS Package - From One Table to Infinite Tables Depending on Data
body: <p>I have a simple requirement. I have a table with Product Names and their Count. I want to create a SSIS package to extract data from one table to infinite tables based on Product Name. 
  In table if i have 10 products then SSIS package should create 10 tables dynamically with one product in each table.</p>
  
  <p><strong>Table Name : Products</strong></p>
  
  <pre><code>ProductName  , QuantitySold
     ABC              10
     xyz              15
     Testing          25
  </code></pre>
  
  <p><strong>Table Name : ABC</strong>                                </p>
  
  <pre><code>ProductName  , QuantitySold
     ABC              10
  </code></pre>
  
  <p><strong>Table Name : XYZ</strong></p>
  
  <pre><code>ProductName  , QuantitySold
     xyz              15
  </code></pre>
  
  <p><strong>Table Name : Testing</strong></p>
  
  <pre><code>ProductName  , QuantitySold
     ABC              10
  </code></pre>