Could you help with my Fuzzy Lookup Problem? No error message but no result in destination table and source/lookup are in yellow

  • I made sure that the reference table and the lookup table have common values first. But still the execution stopped without any error.

    There is '100 rows' showed up between the 'OLE DB Source' and "Fuzzy Lookup' and these two icons stay in yellow. But the 'OLE DB destination' never turned to yellow and when I check the output table it's empty but has column names.

    Please help me! I've been struggling with it for two days and still couldn't make this simple project work!

  • Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1105170-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply