Post reply

Getting new and update row count in SSIS

  • May 20, 2015 at 3:22 am

    #308322

    Hi ,

    In my SSIS Project I am having many lookup.

    for example flow is like below

    having 1 OLEDB Source with 4 lookup task

    then task task is conditional split is used to get new and update count

    if isnull(id) then new and if id>0 then update.

    I want to change the logic of getting new and update row count using lookup.

    could any one help me to achieve the above scenario

    Regards,

    Vipin Jha

  • May 20, 2015 at 4:10 am

    #1799277

    vipin_jha123 (5/20/2015)

    Hi ,

    In my SSIS Project I am having many lookup.

    for example flow is like below

    having 1 OLEDB Source with 4 lookup task

    then task task is conditional split is used to get new and update count

    if isnull(id) then new and if id>0 then update.

    I want to change the logic of getting new and update row count using lookup.

    could any one help me to achieve the above scenario

    Regards,

    Vipin Jha

    Lookups don't provide counts.

    The detail you have provided is scant. It's difficult to help much.

    What's wrong with using a rowcount transaformat?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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