Menu
Drag and drop the Data Flow Task from the toolbox to the control flow region. And rename it as Delete Data using OLEDB Command Transformation in SSIS. Double click on it will open the data flow tab. Next, Drag and drop OLE DB Source and OLE DB Command transformation from the toolbox to the data flow region.
This is the basic syntax for using the DELETE query: DELETE FROM table_name WHERE condition of which row(s) to delete; If you want to delete one row from the table, then you have to specify a condition.
I'm new to SSIS and need help on this one. I found an article which describes how to detect rows which exist and which have changed. The part that I'm missing is how to update rows that changed. I found some articles which say that it's also good solution to delete records which have changed and insert new recordset. The thing is I don't know how to do that step of deleting (red box).
Any suggestions?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With