“The users are getting error processing one of the tables during Re-Formatter process: The locale id of the source column and the locale id of the destination column do not match.”

This error would occur if the table structures of any particular table differ between the source and destination database.

For example if table structure of table UPR00100 in the source company database is different than the table structure of table UPR00100 in the destination company database, SQL server would generate this error while transferring the data from source to destination database.