I got it working. I havn't made any noticeable changes to my package. I created some data viewers to see the data flow in the package. Now my nomatch output is giving me the right data (WA,North,USA) instead of creating a blank for the column that doesnt have a lookup value in the reference dataset(,North,USA).