I have a table with thousands of records which I get from a flat source file.
I need to filter this data and remove duplicate records. I read about SSIS fuzzy logic and grouping and all that.
But I need a simpler way as I have only one table without any relation or highly complex structure.
for e.g. two records with city name 'Bunnell' and 'Bunnel' or 'Fernandia beach' and 'Fernandia bch' should be considered as same.
Any help or suggestion is appreciated very much.
View Complete Post