After running our initial staging jobs, we're now trying to run our nightly ETL to bring new data in. What's happening is that we get so many unique constraint violations, the job fails. We know this probably has something to do with the HASH CRC for each job. When looking at the hash files, HASH CRC is empty. Can anyone give me any tips on how to get the process going, so that when it finds rows that are already there it ignores those and doesn't bring them in, or just updates them, rather than trying to insert duplicate rows?