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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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