Pivot transformation in SSIS (Part 2 of 4).
More SSIS tutorials at http://www.analyticsinaction.com/category/data-integration/. Demonstration of how to pivot data in SQL Server Integration Services (SSIS). The pivot transformation in SSIS essentially performs the same end result as a pivot table in Excel or a crosstab query.
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF