posted 12/11/2009 by AlbertoMunera - Views: [4939]
How to Retrieve AS400/ JD Edwards “for bit data” via SSIS
You have problems with DB2/as400 returning char data in binary format?
Example
Or you are using your OLE DB Source,
When you click Preview you receive this information:
The AS400 systems use a data format called EBCDIC, which is basically an alternate to ASCII.
To solve the problem you need to change the ODBC driver options .
Process Binary as Character = True
Then execute the Preview again.