I seem to be able to connect to the DB2 database easy enough. But when I get back data it looks like this: 0xF9F1F5F0F205 0x05F9F0F8F0F0F0F0 Expense 0xF8F1F0F70505D3A4A38840C395A340404040404040404040404040404040 Instead of the regualar tex/numerics you'd expect. I think I'm missing something to tell it what pagecode to lookup or something. Any help would be appreciated.

you mean to say all numbers are being converted to hex... try setting the usedefaultcodepage to true ... try with a oledb provider.. Ashwani Roy Blog Twitter Please click the Mark as Answer button if a post solves your problem!

This night help you http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/387fe079-1322-4fc0-a93b-d532070463b6 Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

I tried setting default page, and using oledb and no luck. I'm going to try the data conversion. but I still think its a connection manager that isnt config right.

if you have kept all the setting in default configuration for the connection manager and there is still impliciti conversion happening then it is a bug with the provider or something wrong on the DB side (less likely)... Try conversion as you said but this will slow down the data read as the conversion will apply on each and every cell... Honestly I have not seen this happening with the OLEDB provider form DB2 , for my project where I was reading data from DB2 database to the SQL Server Ashwani Roy Blog Twitter Please click the Mark as Answer button if a post solves your problem!

I changed Forced Translate = 37 and now I'm very close. I looked at an old open query a consultant wrote before and the query uses it.

Ahaha ... cool Please update this thread if you get it solved...Ashwani Roy Blog Twitter Please click the Mark as Answer button if a post solves your problem!