In SSIS there is a component for use with Fuzzy logic.
consider using this, in conjunction with your lookup tables, setting the confidence level, to find which value should go to which column...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”