· May 16, 2023
Strange Issues with SSIS

I'm trying to extract data from an IRIS database into SQL server with SSIS using the ODBC driver: InterSystems ODBC35 (ODBC-2023.

I have Unicode turned off in the ODBC settings.
I'm getting strange results - with some tables the SSIS ODBC connector will work but the connector - using the same ODBC driver will. For other tables it's the other way round. The sees the data as unicode and won't allow me to insert it into a non unicode table but ODBC will be fine.

0 1
0 145