SSIS External Column Wrong DataType Auto Detect

Moon Huang 21 Reputation points
2022-11-07T23:05:50.89+00:00

Hi,

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.

258031-image.png

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
    2022-11-07T23:58:20.95+00:00

    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.