SSIS Fuzzy Lookup might help. You can specify a similarity threshold

You could request CDC to be enabled on the table you need to track changes.

You can also request for it to be replicated to a SQL Server database and...

A simple solution to run DTS2000 in 64 bit environment is to install SQL2005 or SQL2008 create a new SSIS package that simply executes the DTS2000 package using the Execute...

What version of Oracle do you have? Oracle has native CDC since version 9i I believe. You could enable Oracle CDC on the source table and simply create an SSIS...

Thanks for recommending my Blog post.:-)

Jose Chinchilla aka @sqljoe

http://www.sqljoe.com