March 30, 2012 at 2:10 pm
I'm converting data from a legacy system to a new system.
There are codes and descriptions but in the legacy system in many instances there not be a code but a description.
I need to consolidate these descriptions and try and match them to a valid code.
Is a fuzzy lookup in SSIS the best best ?
Are there other options?
Has anyone done this before and if so could you please share with me?
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 3, 2012 at 9:00 pm
Welsh Corgi (3/30/2012)
I'm converting data from a legacy system to a new system.There are codes and descriptions but in the legacy system in many instances there not be a code but a description.
I need to consolidate these descriptions and try and match them to a valid code.
Is a fuzzy lookup in SSIS the best best ?
Are there other options?
Has anyone done this before and if so could you please share with me?
Thanks!
I used the Fuzzy Lookup at a previous employer to match descriptions of courses. It took some work tuning the lookup.
Once tuned, it worked great.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply