SSIS how to split a single record in to two different records?
- by Dr. Zim
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,…