title: Look up transformation in SSIS bug:doesn`t prevent insertion of already existing record
body: <p>I have SSIS package that reads from a source, performs look up transofrmation to check if the record exists in the destination , if it exists it redirects to match output and updates it, otherwise to no  match output and inserts it. The problem is that sometimes it inserts a record that should be redirected for update. This is done via job, if I manually execute the package, everything is fine. The look up component is set up correctly with the matching column.</p>
  
  <p>I can`t find out why this happens, the silliest thing is I can not debug it because manually everything is fine.</p>
  
  <p>Any ideas? </p>