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

Moon Huang 21 Reputation points

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,323 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 27,391 Reputation points

    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.


    Zoe Hui

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

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 36,091 Reputation points

    "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

    0 comments No comments