Post reply

Single Excel row to multiple rows

  • January 22, 2010 at 12:55 pm

    #156601

    Hi

    I am planning to transfer data from a source Excel spreadsheet to another desination spreadsheet. But I need to create multiple lines in the destination from a single line in the source depending on conditions.

    Is that possible using SSIS - if so then can anyone provide some tips?

    Many thanks,

    -Nero

  • January 23, 2010 at 2:23 am

    #1107720

    Some sample data (source & desired output) would illuminate this for others who are reading ...

    You are probably going to end up using the Script Component within a dataflow to do this.

    Have a look here for a related example.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • January 28, 2010 at 10:46 am

    #1110225

    NERO (1/22/2010)

    Hi

    I am planning to transfer data from a source Excel spreadsheet to another desination spreadsheet. But I need to create multiple lines in the destination from a single line in the source depending on conditions.

    Is that possible using SSIS - if so then can anyone provide some tips?

    Many thanks,

    -Nero

    Have you tried to use standard Unpivot Transformation?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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