title: How to Pivot a group of columns as rows in output
body: <p>i am trying to convert a file with layout as follows: </p>
  
  <pre><code>id1 | id2 | id3 |...| id34 | A | B | C | A | B | C | A | B | C | 100 group of A B C|
  a1  | b1  | c1  |...| aa1  | 3 | 7 | 5 | 7 | 5 | 3 | 1 | 1 | 1 | ...               |
  a2  | b2  | c2  |...| aa2  | 4 | 3 | 7 | 0 | 4 | 8 | 9 | 8 | 4 | ...               |
  </code></pre>
  
  <p>Output should be:</p>
  
  <pre><code>id1 | id2 | id3 |...| id34 | A | B | C |
  a1  | b1  | c1  |...| aa1  | 3 | 7 | 5 |
  a1  | b1  | c1  |...| aa1  | 7 | 5 | 3 |
  a1  | b1  | c1  |...| aa1  | 1 | 1 | 1 |
  a2  | b2  | c2  |...| aa1  | 4 | 3 | 7 |
  a2  | b2  | c2  |...| aa1  | 0 | 4 | 8 |
  a2  | b2  | c2  |...| aa1  | 9 | 8 | 4 |
  </code></pre>
  
  <p>i'm currently doing it through Script transformation Component
  but its very slow.</p>
  
  <p>i am not very familiar with the Pivot and Unpivot Component</p>
  
  <p>Is there any option which can set the group of rows <code>| A | B | C |</code>
  and SSIS will consider it as one set and convert it in my desired format?</p>
  
  <p>THANKS IN ADVANCE!!</p>