Running a delta load on a source that have inserts and delete rows. But there is no way to run a DELETE FROM sql or a update (delete) write task. Should not the SQL task have more functonality than just select?
This is synapse, and of course there is not a delete in the Table Update Write task :/ Seriously though, Matillion needs to do more for synapse. Just another reason to move to Datafactory instead.