INSERT INTO dbo.ztVenDedup
   SELECT * 
   FROM dswMatchReview_Backup.dbo.ztVenDedup_Backup_20210615_000030

TRUNCATE TABLE dbo.ztStructureCleansing;
INSERT INTO dbo.ztStructureCleansing
   SELECT zSource, KeyField, zSystem, zObject, SetField01, sField01, Field01, dField01, zField01, SetField02, sField02, Field02, dField02, zField02, SetField03, sField03, Field03, dField03, zField03, SetField04, sField04, Field04, dField04, zField04, SetField05, sField05, Field05, dField05, zField05, SetField06, sField06, Field06, dField06, zField06, SetField07, sField07, Field07, dField07, zField07, SetField08, sField08, Field08, dField08, zField08, SetField09, sField09, Field09, dField09, zField09, SetField10, sField10, Field10, dField10, zField10, Comment, zConfirmed, zConfirmedOn, zConfirmedBy, zRejected, zRejectedOn, zRejectedBy, zReviewComment, AddedBy, AddedOn, AddedVia, ChangedBy, ChangedOn, ChangedVia, boaStatus, BatchID, JobExecutionDate, zActive, zCDelta, zCDeltaOn, zCDeltaBy, SourceExtractDate, ExecutionDate, zEmployee, CATEG 
   FROM dbo.ztStructureCleansing_Snapshot_20210622_184721;