SSIS; row redirected to error even after inserting to DB

Question

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.

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.

This happens only when it deployed on server.On running my local machine using BIDS works fine.

Answer 1

My finding might help those who visit here..

@billinkc made a broad comment; i had gone all through that.Well Later after digging down the system the problem was something different.

My SSIS package has script task within to do some operations.That one uses a folder called TEMP in the disk.The program which triggered this SSIS also simultaneously using the same TEMP folder. Now there the file read/write exceptions were not handled. This caused script task to fail resulting a package fail error.Since the INSERT functionality carried before the script task,INSERT was successful.Later when script failed it moved rows to error too!

I tried with catching these "file errors/exceptions" and it worked!!