Another approach would be to use SSIS Data Mining capabilities of Analysis Services http://www.microsoft.com/events/podcasts/default.aspx?topic=Topic-202f8d31-bbff-4d7e-a3f5-c4f19f935a09&audience=Audience-b046181f-3333-4c19-977e-c230ed48d9c0&seriesID=&pageId=x492, this is an excellent video by Donald Farmer. This would still require most of the Profiling, Cleansing, Parsing/Standardization ,Matching, Enrichment, Monitoring steps. You would replace the Matching(Fuzzy) step with the Data Mining Predicative capabilities of Analysis Services.