By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

SSIS and DB2 v9

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.