If the value "fictive Buick Chevron" is present in your example, it will return "Chev" rather than "Buick". It only returns "All Cars" if the data does not contain either...

It should work if you just double click each of your OLE DB sources within your data flow task. Despite the fact that I wasn't requested to modify the metadata,...