When using SSIS with Oracle database, it seems to always assume that a VARCHAR2 maps to a DT_STR. However, if my Oracle encoding is set to AL32UTF8, I should be able to store any unicode character in a VARCHAR2, right? Is there any way to force SSIS to map an Oracle VARCHAR2 to a DT_WSTR? Should there be?
I looked up a few other questions on this, but nothing seems to address it.
I have a data source that has many columns as DT_WSTR, and I want each to go into a VARCHAR2 column without having to convert every column.