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.