I'm totaly new to SSIS. I'm looking for the way to join two tables from different connections and return a result depending on the match. Tables will be LEFT JOINed by ClientID field. It is something like a CASE WHEN in a LEFT JOIN. What
I want to accomplish is the same as the following SQL statement:
when table2.ClientID is null then 'MyStatus'
end as x
table1 left join table2 on table1.ClientID = table2ClientID
Is this possible in SSIS? How can this be done?
Thanks in advance
View Complete Post