I have an issue that I need to catch the transaction ID with the failure message when it fails to insert the row in the target database and send the information to the error output table and have to send that information through an email in SSIS.Can any body help me how to catch the transactions row by row.I am using Try Catch block
You can redirect error rows with in the data flow transformation while inserting into a database . Redirect that to error table . Query the error table in the next task and attaché the result into a mail. Use a send mail task or script task to send formatted email.