I agree with what you're saying here. I guess I wasn't explicit that I'm only using Powershell to find rows that would cause import to the staging table to fail....

I agree. Don't let the bad data get to the database.

I get data files from clients every morning, and they have proven that I can't trust their data.

My strategy...