I have a Product record that has multiple "zoned" prices, one for each store that sells the product.
ProductID int
Name string
PriceA money
PriceB money
PriceC money
In SQL Server Integration Services, I need to split this in to multiple records:
ProductID int
Version string // A, B, or C
Price money // PriceA if A, PriceB if B, etc.
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).