We have two SQL servers, one in our development environment and the second on the production server. Recently, the development server/platform was migrated to Vista Business.
Since then we are facing problems in exporting data using "SQL Server Import and Export Wizard" on to the production server. The following error occurs for all columns in all the tables. There is some Arabic content as well in the database. This was working with Windows XP
Error 0xc02020f4: Data Flow Task: The column "tbTempCustID" cannot be processed because more than one code page (1256 and 1252) are specified for it. (SQL Server Import and Export Wizard)
We have searched all the forums etc to rectify the issue. The most common answer found was to set AlwaysUseDefaultCodePage=true.
I have no clue on how to change this property. It is mentioned as in the Data Flow Properties - Custom Properties. How to reach that module, pls help.
Please let me know if you have any other solutions to the above problem. Thanks in advance.