Post reply

Add new Rows to the dataset based on the number

  • October 19, 2009 at 11:30 am

    #139691

    Hello experts,

    I am trying to add rows based on the division number

    eg : I have the standard quantity 50

    If the inventory number is 120 (which is greater that 50 )

    than i have to create three records

    serial number qty

    xxx01 50

    xxx02 50

    xxx03 20

    how can i do this using SSIS ?

    Thanks a bunch

    Sherly

  • October 20, 2009 at 9:28 am

    #1068296

    SSIS user (10/19/2009)

    Hello experts,

    I am trying to add rows based on the division number

    eg : I have the standard quantity 50

    If the inventory number is 120 (which is greater that 50 )

    than i have to create three records

    serial number qty

    xxx01 50

    xxx02 50

    xxx03 20

    how can i do this using SSIS ?

    Thanks a bunch

    Sherly

    Hi Sherly,

    What I would do is create a custom script transformation component with one asynchronous output. If the required value is <= 50, add one row to the output. If > 50, then create the required amount of extra rows to the output. You can also setup and manage the serial number in the script, too.

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

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

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