SSIS how to split a single record in to two different records? -

I have a product record that has many "zone" prices, one for every product that sells that product.

In SQL Server Integration Services, I need to split it into several records:

Productive int version string // A, B, or C Price Money // Price A, A, Priceby, B, etc.

This will be within a data flow, I think as a change between the Excel source and the OLE DB destination ( Suppose that OLE DB is a good place for MS SQL Server).

Use an excel source, multicast your values ​​(i.e. pricing, priceby, price c) For a flow is divided into. In the split dataphlos, use a derived column, in the first version to create your version value as the string type with the value "A". Again, use a union to combine the dataflow in a dataphlow and map the PriceA to the first one by the output. The output is called price, the price from the second stream to the price, and the price from the third flow to the value of the CR map Please. You have data flow with data recorded three times from now, as you started.