Hi There, We have daily record tracking database, for example, house loan payment table, each loan has has record at this daily table with field such as payment, the database is refreshed daily, so we always find most current day payment information. then we have another database which is called PreviousDay, which is exact the copy of current day data but store previous day record. Now I need to compare record between current day and previous day, if there is difference then I need to keep records for both curent and previous day. I am wondering what is best way to do this?Don

seems that a Slowly Changing Dimension is what you need, there are some ways to do it in SSIS, look at this link: http://blogs.msdn.com/b/mattm/archive/2009/11/13/handling-slowly-changing-dimensions-in-ssis.aspxhttp://www.rad.pasfu.com

Reza, Thanks for quick reply, I will check the link you provide, initially I am thinking about using Except clause to identify the rows.Don

also for more information about SLOWLY CHANGING DIMENSION terminology look here: http://en.wikipedia.org/wiki/Slowly_changing_dimensionhttp://www.rad.pasfu.com