Inserting and Updating works fine, however, deleting a record from the flat file does nothing.
I guess it's something with the Conditional Split: delete
ISNULL(gid_csv) && !ISNULL(gid)
or the following SQL Command:
DELETE FROM dbo.gusers WHERE gid = ?
The OLE DB Source and the three destinations are accessing the same table.
What do I miss?