468,107 Members | 1,340 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

SSIS and DB2 v9

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

Mar 19 '07 #1
1 3099
On Mar 19, 2:14 pm, oregon...@yahoo.com wrote:
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
You may use convert component after you retrieved the data from db2.

Mar 31 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Eric | last post: by
9 posts views Thread by gelangov | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.