Remove dm_site_code from Location tables in Demantra

In 7.3 how to delete the Locations from the demantra tables? The problem is as follows:

1. In the previous collection I had dm_site_code associated with ZONES (MA, TX, IL, etc.)

2. Later, the client changed the zone settings in EBS and merged various states into different new ZONES (Southwest, Southeast, Northwest, etc.)

3. Now, when I run the collection in Demantra again, it tells me that there is a duplicate dm_site_code, so these old dm_site_codes get discarded into t_src_loc_tmpl_err table and therefore, I cannot get the new ZONES into demantra associated with the old dm_site_code.