I have an SSIS package with a Task Transfer Objects step that transfers tables (schemas and data) from one database to another. Databases of source and debits have different sorting. (I do not know if this is consistent with the information.)
In some test environments, some characters (characteristic of Hungarian characters: ő, ű) are converted to inactive (o, u) during transmission. In other test environments, everything is fine (Hungarian accented characters are well tolerated). The columns of the source table are not unicode (varchar), and we cannot change them because it is an outdated system.
Experiments show that this behavior depends on the Windows locale (control panel / region and language / administrative / "language for programs other than Unicode"). If you install Hungarian, then everything is fine, but if it is installed in English, then the Hungarian accents will be lost.
The problem is that I cannot enforce a specific Windows locale, so I'm looking for a way to do it right, which does not depend on the Windows locale.
Is there any way to tell SSIS to use the Hungarian codepage in the transfer?
source share