SSIS External Column Wrong DataType Auto Detect

Moon Huang 21 Reputation points


I am having an issue with the string datatype that the SSIS package automatically detects.

When I open an OLE BD source in the data flow, the External Column DataType for me is automatically detected as "string [DT_STR]", while other of my teammates have "Unicode string [DT_WSTR]" as the data type when they open the same OLE BD source in the data flow. This column is a VARCHAR2 in the database. I am not sure if some kind of user setting causes this?

Did anyone experience a similar issue before? Any help will be appreciated.


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

1 answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,381 Reputation points

    Hi @Moon Huang ,

    • The Oracle VARCHAR2() data type corresponds to the "string [DT_STR]" SSIS pipeline data type.
    • The Oracle NVARCHAR2() data type corresponds to the "Unicode string [DT_WSTR]" SSIS pipeline data type.

    As end result, your SSIS OLE DB source in the data flow is correct.

    1 person found this answer helpful.