Update is being blocked by Select for lookup transform

• WSquared

  SSCrazy

  Points: 2393

  More actions

  November 8, 2006 at 12:22 pm

  #117599

  Hi All,

  I have a situation where in SSIS, I am using a lookup transform to check if the record exists, and if it does then I update it, however, the select for the lookup transform blocks the update occassionally.

  Any ideas would be greatly appreciated

• Daniel Forrester 123

  SSCrazy

  Points: 2216

  More actions

  November 9, 2006 at 3:03 am

  #670786

  Sounds like this might be easier via a simple update statement?

  Regards

  Daniel