Fuzzy Lookup outputs per Match RRS feed

  • Question

  • I am currently working on an fuzzy lookup solution in SSIS 2012. Currently my lookup transform is set up such that it returns 1 match per input. It has come out from the development team that we should have a max of 3 matches per input. If I change the setting in my transform to do this how can I the select the match with the highest similarity and confidence out all matches returned per input. The rows per input with the highest confidence and similarity are used further down the dataflow for other transformations.

    Tuesday, April 2, 2013 2:56 PM


  • I managed to solve this by using a script component to compare the previous row with the current row. Previous row fields where stored in variables. If anyone is interested in the script they can contact me at
    • Marked as answer by Sauce1979 Wednesday, April 10, 2013 7:35 PM
    Wednesday, April 10, 2013 7:34 PM

All replies