· 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.

In some cases I'm getting data that just looks screwed up  

Anyone had similar issues? Anyone successfully using SSIS with IRIS?

Product version: IRIS 2023.1
Discussion (1)0
Log in or sign up to continue