Hi

Here is very good example of incremental load http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx

As the last step add Execute T-SQL Statement Task to update status_flag = 'D' for rows which are not exist in Staging table.

Best regards

Mike