I'm really struggling with how to figure out adding in a FK constraint during a process that gets data from one sever and inserts into another. I've tried derived column, lookup, and just sql scripts. Any of the three may work, but I can't figure out any of them. Some direction would really be appreciated.
There is an exception to every rule, except this one...