title: SSIS; row redirected to error even after inserting to DB
body: <p>I have a SSIS package to insert/update rows to Database. First i use look up for checking if row already inserted to DB;If yes i update that row, else insert as new row.</p>
  
  <p>My problem is when inserting , a row is inserted successfully but also redirected to error. How both can happen at same time? That too it happens some times not always - very inconsistent. How to track what caused the error ? I used "redirect row" here to get failed rows.</p>
  
  <p><img src="https://i.stack.imgur.com/0yiWs.png" alt="enter image description here"></p>
  
  <p>This happens only when it deployed on server.On running my local machine using BIDS works fine.</p>