Fuzzy Lookup and Fuzzy Grouping in DTS for SQL Server 2005

Fuzzy Lookup and Fuzzy Grouping in Data Transformation Services for SQL Server 2005 on MSDN takes a look at the "Fuzzy Lookup Transformation" and "Fuzzy Lookup Grouping transformation" (those are the real names of the DTS objects) in Yukon's DTS.

The purpose is to leverage general search algorithms to reduce complex code for the ourposes of lookups and data cleansing. Very interesting, and shows that Microsoft is serious about making DTS a full-fledged ETL tool.

In another article I saw a week ago that I can't locate right now, an analysts pointed out that there will be many new features in SQL Server 2005, but they will require alot of training to take advantage of. All things told, that's pretty much the case with SQL Server 2000, but it looks like SQL Server 2005 will be especially so.