Hi All,

I need to implement an SSIS package wherein during the run time (i.e. during
the data load), the package should check / match the fact data between the
source and target systems. For eg, if it's a Sales measure in one of the fact
tables, then it should reconcile this value between the two systems. If the
sales value doesn't match, then it should shoot a mail notifying about the
failed reconciliation. I surfed through some articles, but no luck.

Can anybody provide a solution to this problem? Or point me to some link
where i can the details/solution?

Best Regards,
Bhushan