Sample Header Ad - 728x90

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 ). enter image description here **Merge Join**: enter image description here 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) enter image description here or the following SQL Command: DELETE FROM dbo.gusers WHERE gid = ? enter image description here The OLE DB Source and the three destinations are accessing the same table. What do I miss?
Asked by wp78de (317 rep)
May 14, 2019, 05:18 PM
Last activity: Dec 17, 2020, 12:00 PM