SSIS 2008 Fuzzy Grouping
Why is my data actually getting modified when performing a Fuzzy group match on a set of fields ... bizarreWierd things are getting tacked onto the end of my data like .ANY or WO TO ... What is going on?
February 23rd, 2010 2:26am

Why is my data actually getting modified when performing a Fuzzy group match on a set of fields ... bizarreWierd things are getting tacked onto the end of my data like .ANY or WO TO ... What is going on? Hi,How do you use the Fuzzy Grouping? Based on my test, I can't reproduce this issue, I suggest you go through the following links about "How to use Fuzzy Grouping".http://msdn.microsoft.com/en-us/library/ms345128(SQL.90).aspx#fzdtssql05_topic4http://www.bimonkey.com/2009/11/the-fuzzy-grouping-transformation/Please feel free to let me know if I’ve misunderstood anything.Please remember to mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2010 10:08am

Were you ever able to solve this? I'm having the exact same issue. It's as if parts of other rows are being concatenated to the ends of some fields. And it's somewhat random. For example, I have a "Title" field that is filled with CEO, COO, Accounting, Operations, Branch Administration, etc. Many of the results of the Fuzzy Grouping say something like "CEOnch Administration" or "CFOounting". My City and Email fields are also doing it. Thanks!
July 29th, 2011 4:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics