March 23, 2010 at 6:33 am
I have a table full of old archive data that I need to clean before I can use.
The old records were referenced by an owner which was a free text field and as a result I have many choices for a single user.
In the new system I am trying to change the user references to a single id, but am having trouble working out an approach to perform the task of matching old names used with the actual username.
Old names
========
SMADDEN
Steve Madden
S Madden
Stephen Madden
smadde
Username ID
======= ==
s madden 213
Is this a manual task?
Cheers...Steve
March 23, 2010 at 6:45 am
Looks like I may be a bit premature with my question. I am going to have a go at it using SSIS and fuzzy lookup, looks like it may be the thing for my problem. 😀
September 28, 2017 at 7:00 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply