• LutzM (4/19/2014)


    Why don't you just use a conditional split with a left outer join to the table holding the primary key. Check for NOT NULL of the PK value and perform the insert.

    Do whatever needs to be done with the rows not matching the PK.

    Can't figure out how to use a conditional split with a left outer join to the table holding the primary key. Can you be more specific please?

    There is an exception to every rule, except this one...