Hi,

Sorry for the delayed reply, work has been mad.

It's a difficult one to do unless you are loading in a full table each time (and not doing anything incrementally). If this is the case then create an additional source from your destination table and do a lookup to your source. If any of the keys in our destination do not exist in your source (this can be achieved via a conditional split) then use a sql component to delete them (or retire them with a flag, whichever suits). It's a bit dirty but if you have a source system that allows physical deletes then you're a bit stuck with it. :crazy: