We are attempting to load a DB2 v9 table with SQL Server Integration
Services.  The DB2 data exists on AIX and is built with a codeset of
1252.  The SSIS server has the DB2 V9 client and we are using the OLE/
DB driver.  When we try and connect the two SSIS insists that we have
to treat the char (and varchar) data as Unicode.  At this point I
believe the issue is most likely being caused by either SSIS or the
DB2 OLE/DB driver.

Has anyone run into a similar problem and figured out how to avoid the
unicode conversion?

Jack