SSIS Merge Join: Delete does not work
3
votes
1
answer
553
views
I've set up a Data Flow Task to sync a flat file with its destination table using a Merge Join with a Left Outer Join as described here (and elsewhere ).
**Merge Join**:
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
or the following SQL Command:
The OLE DB Source and the three destinations are accessing the same table.
What do I miss?


ISNULL(gid_csv) && !ISNULL(gid)

DELETE FROM dbo.gusers WHERE gid = ?

Asked by wp78de
(317 rep)
May 14, 2019, 05:18 PM
Last activity: Dec 17, 2020, 12:00 PM
Last activity: Dec 17, 2020, 12:00 PM