The fuzzy lookup package created in lesson 26 fails to complete. I'm not sure if this is because I'm running SQL Server 2008 R2. The Lookup step passes records through to the Union All step and the Fuzzy Lookup step and all these steps turn yellow, but none of them complete. SQLDumper runs and creates a dump file, indicating an error occurred, but the package doesn't do anything more except indicating that is has completed without any errors or any other steps completing. Is anyone else experiencing this problem or does anyone have a solution?

I've tried running the package without the regular Lookup step and it still fails without any errors or completing the Fuzzy Lookup, so I think the problem is in the Fuzzy Lookup step.

I am running SQL8R2 all patched up on Win7 Pro x64 all patched up ...
Cannot determine where the issue lies. Match output from Lookup flows to EOJ and lands in the db table. No Match output flows to Fuzzy Lookup and stops there it seems
HELP? anyone? Authors?? Publishers???
Pls advise!

Hello, I am having the same issue, I cant find an answer, did either of you work out what it was in the end? I'm running 2008 R2 SP1, then upgraded to SP2 in case it solved it, which it didnt.

Project > (Project) Properties

Make sure Run64BitRuntime is set to True. You likely changed it to False for one of the earlier lessons.