Why a Fuzzy Lookup returns Null set of values from the reference table

• radb4u

  SSC Eights!

  Points: 917

  More actions

  May 6, 2011 at 8:04 am

  #239765

  Hi,

  I am newly learning SSIS for my new task. I have taken a source table (fname, lname, addr1, addr2, addr3) then trying to transfer the data to customer name and address tables. When I was trying to fuzzy match on first name with similarity threshold 0.29, it is showing all Null values for the reference table fields (customer name) which doesn't match (ex: source fn: Tom, ref fn: Tomas) and threshold value as 0. Exactly match once are fine with threshold value 1 and exact reference column values. Please let me know what I am missing here.

  Thanks in advance.

• radb4u

  SSC Eights!

  Points: 917

  More actions

  May 6, 2011 at 9:27 am

  #1321102

  I found that if I take any other exact match column with the existing one then it is showing the reference values as well as the threshold values. I don't know the reason but, it is kind of solution to my issue. Thank you.