Getting new and update row count in SSIS

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 246979

  More actions

  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