Incremental load in SSIS using Lookup task: Incremental Load (DELETE) | Manage Deleted Source Data

In this video we will see how to incremental data load (DELETE) using SSIS.
This is going to be a detailed walk through providing all the necessary steps for you to DIY.
Also note that this will be a continuation from the previous video:
www.youtube.co....
• SSIS Series: Increment...
Install SSIS: Visual Studio 2017/2019
docs.microsoft....

[@divyasukumar7324]

Thanks a lot for the detailed explanation...

[@dataexplained7305]

You welcome...

[@DeRups_NL]

How can i fix this when my source an ODBC is? My Target table is an OLED DB Destination. But when i want to look backup to my source i cant use the lookup functionallity.

[@majlindekastrati2334]

i have done the update in OLEDB task to make isDeleted=1 where PrimaryKeyColumn=? even i did not delete any record in source table, all the values of isdeleted column in destination as marked as 1

[@nazman999]

Excellent series on SSIS. Straight forward to follow. Thank you for sharing. Would the approach of Loading, Updating and Deleting of records using SSIS be more efficient then using SQL Server Transactional Replication? Cheers

[@dataexplained7305]

Hi Nazim, SSIS is a batch process which moves data from source to target at a specified time only. Other times you can see delta between source and target. Tran replica is a near realime processing. There are processes like MSins, MSupd and delete for transformjng the published datasets before coming loaded into the subscriber tables. Hope this helps..

[@mythilysenthilkumar6222]

Hi, video explanation is nice. Can i have a video that how to make a Isdeleted column as false while execute from source to destination table. And Is all insert, delete and update done in same package like this one way or any other option is there? can you reply me please.

[@dataexplained7305]

Thanks for the Q. 1) Yes you can make isdelete column to a default value via a derived column and then load to target.. should be a straight forward one. 2) You can insert delete and update in same package yes and also as seperate packages but they need to be sequenced via a execute process task which calls the respective packages in sequence.

[@mythilysenthilkumar6222]

@@dataexplained7305 Thank you so much for your reply