How To Use the Unpivot Transform in SSIS

Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be through a series of unions in T-SQL, but that's just ugly and means lots of passes at the data potentially. You could use a T-SQL unpivot, which ...