I Was able to solve the problem by moving the reference table the the dbo schema. For some reason having this in my own schema didn't work. I changed the...
Fuzzy lookup, but I have example code from the book hands on sql server integration services that works just fine-the only difference is that I've loaded it on my local instance of...