Sequential Fuzzy Lookup RRS feed

  • Question

  • I am currently working on a package that takes 3 source fields and does a fuzzy lookup to on all three fields to determine if a match can be found. The flow is a follows:

    Assume there are 3 fields Field A, Field B, Field C

    First take  field A and Field B and do a fuzzy lookup using those fields and bring back a max of 3 Matches.

    Along with the matches I return 1 other field , Field D.

    I then need to use Field C and do a fuzzy lookup on Field D with the 3 Matches returned from the first lookup.

    How can I implement this in SSIS?

    Friday, April 19, 2013 8:00 AM


  • I propose you dump the results of the Fuzzy Lookup op #1 into cache, then use it to drive the Fuzzy Lookup #2.

    http://www.mssqltips.com/sqlservertip/1511/lookup-and-cache-transforms-in-sql-server-integration-services/ as an example

    Arthur My Blog

    • Marked as answer by Eileen Zhao Thursday, April 25, 2013 5:55 AM
    Friday, April 19, 2013 1:43 PM