It would seem the post ends with :

Create a districtid column in the 'replication tables' and make it a composite key.

for example:

USE [DIMSCONSOLIDATEDData]

G

I'd like to see the rest of...