 Hello, welcome to SSUnited Social Decide and this is continuation of SSIS tutorial. So today we gonna discuss about incremental load delete. If you haven't watched last 2 videos of this video series, so before going forward I would strongly recommend to watch that video where you can understand about the what is incremental load and why it's required. Then we have discussed about incremental load within certain update. So today we are dealing with incremental delete. So let's start with incremental delete. So go to on ssms and this is our source table and this is our destination table. As we have discussed in our last 2 videos. So once we will delete anything in our source table and we will run our package then in our destination table actually we don't want to delete data from destination table. We just want to update the flag which is deleted in our destination table with true. So how we can achieve this? So go to on ssgt and this is our package which we have discussed in our last video. So I am going to use that one and here I would like to use a new dataflow task and this is for delete. So we can connect with our existing dataflow task and we can rename this with delete. So this is our delete task. So now double click on this delete task. So inside this dataflow task whatever plan I just want to get data from destination table this time and we are not getting the data from source table. So once we will get data from destination table then we will apply lookup with our source table like we are having 1112 in our destination table and in our source table we don't have 11 and 12. Like I want to delete these two rows so data is not available in source table. So once our lookup transformation will work then in destination table we will get 12 rows and in our source table we will get only 10 rows. So in no match output we will get two rows which is 11 and 12. Then by using OLEDV command transformation we will update these two rows. So go to on ssdt and here I wish to use source as OLEDV source and we want to use lookup transformation so I can drag and drop this lookup transformation. After that I need to use OLEDV command to update the deleted column. Double click on this OLEDV source. So here I want to pick data from destination table. So destination connection manager that is fine now click on OK. Then we need to select the table. So here I would like to select our destination table. So we can select and we can check we have 12 rows that is fine. Now we can click on OK. Now we need to connect with lookup transformation. I need to configure our lookup transformation. Double click on this lookup transformation already pick an exam manager that is fine. And here as we have discussed we need to use redirect rows to no match output if any row is not going to match with our lookup table. Go to on connections. So inside this connection we want to check in source table. So we can select our source connection manager that is fine. So here this is our source table looks good. Go to on columns and here I would like to map with employee ID that is fine now click on OK. Then we need to connect this lookup transformation with already be command. And here I would like to connect with no match output if data is not going to match from destination to source. Then we want to move in already be command double click on this already be command connection manager destination connection that is fine. So refresh looks good connection properties here we need to specify our update statement. I would like to update destination table so that is EMP destination then we want to set is deleted is one where EMP ID is equals to something click on OK go to one column mapping. So this is our parameter and we need to map this with EMP ID that is fine click on OK. So now we have done our package. So once our package will be executed then we should have 11 and 12 with true in is deleted column now go to one ssdt and execute our package. So package executed successfully as we can see from source we are getting 12 rows after lookup transformation we are getting only two rows so two rows that is 11 and 12 that should be updated. So you stop this package and go to an ssms and here I would like to refresh this table by pressing control R. So as you can see for 11 and 12 we are getting is deleted with true. So I hope you have understand how we can deal with incremental load delete. So if you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.