0

I have an excel file as shown belowenter image description here

I need to load these data into a table with below mentioned format

enter image description here

How to achieve this in SSIS.I mean all the column header would insert as row element as shown below.Is it using pivot ?

Community
  • 1
  • 1
user1254579
  • 3,901
  • 21
  • 65
  • 104

1 Answers1

1

I believe you actually need to UNPIVOT the data; it would look like this:

Input Column | Destination Column | Pivot Key Value
Period1      | Value              | Period1
Period2      | Value              | Period2
Period3      | Value              | Period3
Period4      | Value              | Period4

With the Pivot Key Value Column Name: Period

Peter_R
  • 642
  • 1
  • 7
  • 12
  • 1
    @user1254579 Sorry I think I got it the wrong way around it needs ot be Value as the destination and Period as the Pivot Key Value Column Name. – Peter_R Mar 06 '14 at 16:09
  • Yes value is destination column ..But I have multiple periods in the input file,so in this CASE WHICH period has to be taken as pivotkey. – user1254579 Mar 06 '14 at 16:19
  • 1
    Pivot Key Value Column Name: Period - Will generate a new column called Period, which will then be populated with Period1, Period2, Period3, Period4 as that is what is in the Pivot Key value. – Peter_R Mar 06 '14 at 16:29