title: SSIS how to split a single record in to two different records?
body: <p>I have a Product record that has multiple "zoned" prices, one for each store that sells the product.</p>
  
  <pre><code>ProductID int
  Name      string
  PriceA    money
  PriceB    money
  PriceC    money
  </code></pre>
  
  <p>In SQL Server Integration Services, I need to split this in to multiple records:</p>
  
  <pre><code>ProductID int
  Version   string  // A, B, or C
  Price     money   // PriceA if A, PriceB if B, etc.
  </code></pre>
  
  <p>This would be within a Data Flow, I presume as a Transformation between Excel source and OLE DB destination.  (Assuming OLE DB is a good destination for MS SQL server).</p>