There is a need to cleanse and validate data when received and on a regular basis to not waste resources. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset.