Thank you SSCrazy I will try this.

Thank you very much SSCoach. That's what I was looking for.

I would simply delete those 15 million records from source tables and that delete operation will be replicated to the destination table which will remove those records from destination tables...