Well, so far you are on the right track.

Deletes:

You would have to use a OLEDB Command for that. Depending on number of rows (How many are the BTW) this may end up hurting you. I will explain a different way if it is large.

For the insert, you should use a lookup component. In the Advanced tab, enable Memory Restriction. This forces it to look for each row as it arrives instead of caching it all before hand. Again, large sets will perform slowly. There are other ways.

Question though: You say there are inserts without deletes. How do you ever get new data? First time records - would they still have a delete?