Executing a staging area table results in an error message.
The locale id '####' of the source column '<ColumnName>' and the locale id '####' of the destination column '<ColumnName>' do not match.
The TX DWA staging area database and one or more of the data source databases are using different collation options.
Check "Force Codepage Conversion" in the data source settings. This will ensure that TX DWA is able to translate the source data into a format the staging area database can understand.
Note that if you add an additional connection that requires this option to an existing data source, you must select "Force Codepage Conversion" in the options for that new connection. You must take this step even if you've already selected the option in the primary data source's settings. The reason for this is that additional connections do not inherit any settings from the primary data source.
Having this option enabled for the main data source but not for an additional connection is a common cause for this error.