We are going to a new server (Windows Server 2012) with SQL 2012 from SQL 2005. We have the DB2 client installed and a linked server configured in order to use OpenQuery to import data, which we do using SSIS. The problem is that, in the new environment, all the string data is now being seen as Unicode. This creates a huge hassle updating the dataflow tasks in the import package by having to add a Data Conversion transform and re-map all the fields.
Does anyone intimate with the DB2 client and SQL Server 2012 know of a setting or change in the DB2 client or linked server configuration in SQL Server 2012 that might cause this change?
I am not the one who installed the client or configured the linked server and so want to pass along anything I can to our DBA folks to get this resolved.