I have a Data Flow task that implement Insert/Update using logic:
Now I want to also include "Delete" just after the OLEDB Source where I will delete from Target Table if the Rows are present in Target and No in the OLEDB Source. So what control I should use and how do I refer to the OLEDB Source records.
May be something like: Delete from dest_table where ID NOT IN (SELECT ID from OLEDBSourceControlRecords)...
View Complete Post