Change Data Capture without modification date

[#1]

Hi,

Would request if somebody can help me with this:

I have a source table coming from a FoxPro system like the one below:

ID	Name	Region
001	ABC	New York
002	DEF	Miami
003	GHI	London

Now the Value of 'Region' is changed randomly without any information - this affects my application since I've applied Section Access based on values of 'Region'. e.g. if a user is given access to data related to 'London' and the 'London' value is replaced with 'New London' - that user would not find any data.

I'm required to find a solution that "maintains historical data & records any changes made in the Region field. Also if it sends out alerts/emails that would be great.

Note:

1. There is no modification time or date available in the table/source.

2. This table is scheduled for reload daily.

Would really appreciate any help on this.

Thanks

Harry