There was no way to know that the individual running the script didn't have sysadmin rights!

Which master table is it?  I don't see one directly related to dts.

I have SSN, salary, customer names and etc that I need to scramble the data within those fields so a third party vendor can't read it.