We have an SSIS package (2010) which has had no error handling. I am now adding it. I am redirecting and capturing errors in a flat file but the user doesn't want the good rows to be processed. If any errors, he wants the package to fail. They will fix the file manually and resubmit it. I want to give them the entire file with the errors noted. I was thinking I could put error rows into one file, good rows into another and combine them and email them to the user but I don't know how to get only the good rows. Am I making this too difficult? Thank you for any ideas you can provide.
