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!