problems with codepage

How to convert a flat file source in 65001 codepage to 1252 OLE DB connection ?

You can try the following:

- Edit your flat file connection manager and set the code page to 65001.
- Define you flat file columns
- Go to the "Advanced" page and change data types in the columns you want to convert from "string [DT_STR]" to "Unicode string [DT_WSTR]".
- Define your Flat File Source to use the newly created connection manager.
- Drop a Data Conversion transform and connect it to the Flat File Source one.
- Select the columns you want to convert and set their data types to "String [DT_STR]" and their code pages to "1252 (ANSI - Latin I)".
- Add an OLE DB Destination adapter and map the destination columns to the converted ones.

HTH.

Thanks,

|||You should be able to specify the code page of 65001 when configuring the flat file connection.

You will likely have to use two data convert transforms downstream, one to convert the 65001 into unicode, and the other to convert the unicode into 1252.

jkh