Post reply

Data manipulation issue

  • February 15, 2007 at 1:45 pm

    #153437

    Hi

     

    I am facing a issue while writing a SSIS. The requirement is as below:

     

    Source Table; Have Col A,B,C,D,

    Destination Table: Have Col X

    Aim:

    Values of cells in A,B,C,D for each row will be inserted in Destination table’s X column as independent column. [ie. For each row in source, there will be 4 rows in destination]

     

    Could any one kindly guide me on how to proceed? Thanks in advance.

     

    Regards

    Utsab Chattopadhyay


    CDBA

  • February 19, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • February 20, 2007 at 11:50 am

    #690722

    Thanks Site owners. I am still struggling and started to believe that may be we need to write a .net script for it. Any other thoughts please?

     

    Regards

    Utsab Chattopadhyay


    CDBA

  • March 5, 2007 at 11:59 am

    #693187

    If I understand your problem correctly, I think that the Unpivot transformation should work.

    http://msdn2.microsoft.com/en-us/library/ms141723.aspx

  • March 9, 2007 at 6:48 am

    #694075

    Note also that if this is a SQL Server table, there is a PIVOT and UNPIVOT option in T-SQL. You may find this easier to implement than the un/pivoting components in the dataflow transformations as they are quite laborious to set up!

    You should be able to find out the syntax from books online.

    Kindest Regards,

    Frank Bazan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply