Anyone writing data to DB2 on an AS400 with SSIS?
I cannot get the OLEDB destination configured correctly.ÃÂ I can set the destination up with a SELECT sql query, and preview the resultset.
View Complete Post
I will need your advice on a SSIS package which moves IBM DB2 (for z/OS V7) data to Oracle (AIX 10g). Thank you in advance.
Basically, this is a very simple SSIS package (created by SSIS import / export wizard) and just maps column by column. I used IBM OLEDB provider for DB2 to connect the source and Oracle Provider for OLEDB to connect to the destination.
The problem I ran into was that if the DB2 source value contains special (or invisible) characters then this value will be converted to a SPACE (' ') value on Oracle. To be more detailed, take the following example:
On DB2, value 000002D0000002D7 (EBCDIC HEX codes). This is actually a value of a column defined on DB2 as CHAR(8). Please note HEX '00' in EBCDIC stands for NULL and HEX 'D0' stands for character 'K';
On Oracle, this value will be stored as a SPACE (or a string of SPACEs) after data move.
On both DB2 and Oracle this column was defined as CHAR(8).
I guessed this was related to a code page issue, so I tried a few different code page to set for the source property (by setting the DefaultCodePage of the DataFlow source property), I used code page 37, 500, etc... All resulted in the same Oracle value.
The character set on DB2 is EBCDIC and the one on Oracle is ALT32UTF8. I guess it was the source provid
Please comment the pros and cons of both methods.
Thanks in advance.