Hello,
I am trying to migrate ISAM data(transoft ODBC driver)on windows to
Informix(on AIX) through SSIS(Components Ado.net connection for ISAM ,
Oledb connection for Informix).
1)I am able to move int datatype data to informix int data type.
2)when the data type is PIC X(8) and informix datatype is char, data is
not getting transferred(the field is blank).I have changed the ISAM PIC
X(8) datatype to string(dt_str) using dataconversion component of SSIS
to prevent unicode non-unicode error.
3)when the data type is PIC X(8) and informix datatype is varchar, data
is getting transferred.But i am not supposed to change informix
datataype.


Can you please help on this.

Regards
Smiley


*** Sent via Developersdex http://www.developersdex.com ***