I have a package which was scheduled to run on sat and the rows_processed = 900000 and rows_inserted = 162. The package flow consists of some lookup's with ignore failure option.If any of the lookup fails/mismatches they are written to the audit tables. But there were no rows written to the audit table. When i tried running the package today ...i could see the rows_processed and rows_inserted counts are matching Any inputs please....this should run on prod tomo.

How did you create the "If any of the lookup fails/mismatches they are written to the audit tables" portion?Arthur My Blog

It would like, if in any of the lookup there is a mismatch then it would write nulls into it.....and those nulls are processed to written into a separate table k.sravani

Write nulls into where? Not sure but seems that you want to run the T-SQL Merge and if it does not get anything flagged then you action this. You can also try this approach: Get all from table A that is not in B: http://www.sqlis.com/sqlis/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspxArthur My Blog