Phil Parkin (2/5/2014)
I tried the UNPIVOT transformation for this problem and after pratting about with it for a while in an attempt to make it work, I have come down soundly on the side of Jeff and Sean - do this outside of SSIS.
And if you think the UNPIVOT has an unholy GUI, try the PIVOT one for a change...
:hehe:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP