I have been playing with DTS - and came across "Fuzzy Lookup". This looks to be a very welcome addition when performing ETL - its aim is to clean the data on the way through. It uses "fuzzy logic" to match the source data (misspelt, abbreviated, truncated etc) with clean lookup data and replace the original "dirty" data with a much cleaner form. I am impressed. I then went on to discover this great article http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/FzDTSSQL05.asp which is worth sharing. Enjoy...