You can try with the ALIAS statement. It allows you to define an automatic rename for fields with slightly deviating field names before you load them. For example,
ALIAS [First_Column] as [First Column];
will force an implicit rename in each subsequent LOAD or SELECT. Of course, the script will not automatically detect other new variations on the same field name. Artificial Intelligence is not (yet) built into the script engine .
So whenever you detect a new naming deviation, you 'll have to add it to the corresponding ALIAS statement. If you put all ALIASes in an external script and include that one in every load script, management of field naming becomes very straightforward.