SSIS Data Flow Task OLE DB return column value with encoding issue

Question

I am working on an SSIS package to transfer data from one Oracle table to another. I use OLE BD Source and OLE BD Destination in SSIS. The rows are transferred successfully, but on the destination table, some of the column values seem to have encoding issues.

For Example, the address column in the original table has "1123 - 332 A Street", but the destination table ends up having "1123 ¿ 332 A Street".

Did anyone encounter a similar issue before? I will really appreciate any help!

I tried changing the AlwaysUseDefaultCodePage from False to True, but I still have the same issue.

Answer 1

Hi @Moon Huang ,

It seems that the issue is related with your Oracle setting.

As said here how-to-escape-dash-on-oracle-when-updating-table, there is a difference between – and -.

You may have a double check, also refer to how-to-store-hyphen-dash-in-oracle-varchar2.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

"1123 - 332 A Street", but the destination table ends up having "1123 ¿ 332 A Street".

Then source and destination have different encodings, e.g. Oracle = UTF-8 and MS SQL = Unicode/Ascii.
You have to convert the encoding: Data Conversion Transformation