Automatically Add Join Conditions Using Foreign Keys
The Automatically add join conditions option
in the Data Flow Designer now uses primary-foreign key relationships,
if they exist in the synonym. This is used to determine what conditions
to add, before using matching column names.