title: SSIS read the data from table and insert 2 rows in another table
body: <p>I have a requirement to read the data rows from one source table and insert different rows in another table</p>
  
  <p>I have tried reading the rows from the table and inserting is working fine using data flow in SSIS</p>
  
  <p>But based on the source rows(split source and insert into 2 rows in destination) based on Common ID</p>
  
  <p>i.e Source System ID and Source System Key in one row and targetSystemID and Target system key in another row with same commonID,RefID</p>
  
  <p>Example:</p>
  
  <p>Source table columns &amp; rows</p>
  
  <pre><code>RefID      SourceSystemID     SourceKey     TargetSystemID   TargetKey     CommonID   KeyDate
  3           1                 9BFG06E8AD      2              001351913001  12345      20-02-2010 
  4           1                 8KIJ67ASG9      2              002352014005  45678      20-02-2010 
  </code></pre>
  
  <p>Required destination column rows</p>
  
  <pre><code>DataID(AutoIncrement)    RefID      SystemID          SystemKey      CommonID    DateCreated(using getdate())
  1                        3          1                 9BFG06E8AD     12345       getdate()
  2                        3          2                 001351913001   12345       getdate()
  3                        4          1                 8KIJ67ASG9     45678       getdate()
  4                        4          2                 002352014005   45678       getdate()
  </code></pre>
  
  <p>Can anyone assist please?</p>