How to use Pivot Transformation in SSIS Package

Pivot Transformation is used to convert Row Data into Columns. Pivot transformations makes normalized data less normalized.

In this video you will learn
Why do we need to use Pivot Transformation
Demo: How to use Pivot Transformation and details about Pivot Transformation Window setup

Pivot Key : Provide the column name which value you want to convert to columns
Set Key : Provide the column which values will be grouped as a row value
Pivot Value: Provide the column which has values

Note : You can ignore to provide the values and run your package in debug and then copy from output window or progress window and reopen and provide in Generate pivot output Column from values text box. As I know the values for my column those are month names , I have provided by myself or I could have run the package with Ignore and copy them later.


How to use Pivot Transformation in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

3 comments:

  1. It is really frustrating when you do not share your source data, now i have to draw up it from scratch and it takes allot of time

    ReplyDelete
  2. Kendriya Vidyalaya 9th Class Final Exam Pass Students Join next 10th Class Academic Year -2023, Kendriya Vidyalaya 9th Class Students Download Syllabus 2023 Regular Reading new Syllabus 2023 for Exam Easy to Pass for the Academic Year -2023, Students Download your KVS 9th Class Curriculum Split Up Syllabus 2023 Online Pdf Format This year KVS has Announced 9th Split Up Syllabus 2023 for for the subjects Class 9 Maths, Science, Social Science, Hindi, English, Sanskrit, Urdu, Health and Physical Education etc. have a look at the KVS 9th Exam Pattern and Syllabus 2023, KVS 9th Class Syllabus 2023 Here, we have Downloaded the Different Chapters of all the books and Combined them into Pdf Format, KVS 9th Syllabus 2023 & Books 2023 Download Regular Reading Good Performs in for All Exams for the Academic Year 2023.

    ReplyDelete