Error: The locale id of the source column and the locale id of the destination column do not match ids of the source column and the destination column

Symptoms

When deploying a project the following error message is displayed.

Error: The locale id '1030' of the source column 'DW_Account' and the locale id '1033' of the destination column 'DW_Account' Solution: Enable 'Force Codepage Conversion,

Resolution

1. Navigate to the Data Sources node in the project and right click the data source, select Edit Microsoft SQL Provider.

   

2. Check the box that reads Force Codepage Conversion.

   

3. Re-attempt the Manual Deployment and Execution of the project.