How To Use the Unpivot Transform in SSIS

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

2 Responses

  1. alex says:

    This is great! I have similar situation:
    Vehicle_Id, Date_time, Chan_1, ….. Chan_N.
    I want to achieve:

    Vehicle_id, Date/Time, Chan_1, Value
    Vehicle_id, Date/Time, Chan_2, Value
    Vehicle_id, Date/Time, Chan_N, Value

    Vehicle_Id does not change, Date/Time is a timestamp. Compared to your example I need one column – Costomer_Id, in my case I have 2 – Vehicle_id and Date/Time. Can I achieve the same result with two columns without conversion and concatenation. The input file is csv with data coming from sensors, I have Vehicle_Id, Date/Time and a value per a sensor channel.

  2. good article, helped me understand unpivoting 🙂

Leave a Reply