I'm trying to populate a field from a field in a different table (same database). Essentially it's a "lookup" operation. I want to use the "lookup" feature under "Transform Data Task Properties" but I don't understand how to make it work. Any help appreciated.
Bill