Post reply

how to split data in ssis

  • September 19, 2011 at 10:03 pm

    #248161

    Hi Friends ,

    source data comes like id , name , sal

    1 , ravi , 100,2000,2500,3000

    how to load the this data into destination table data like

    id,name,sal

    1,ravi,100

    1,ravi,2000

    1,ravi,2500

    1,ravi,3000

    plz solve this problem in ssis

  • September 20, 2011 at 8:00 am

    #1383863

    Use the pivot task.

  • September 20, 2011 at 8:21 am

    #1383874

    if the number of 'sal' columns is fixed to Four then i would create Four seperate data sources, one for each column, and then send these all to the same table with a derived coulmn to indicate the row number.

Viewing 3 posts - 1 through 2 (of 2 total)

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