Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SQL 2005 DTS giving Junk characters in DB2

Author  Topic  Pkumar Starting Member 1 Post Posted - 2007-05-15 : 04:36:45 Hello Friends, I need a help for SQL 2005 DTS. I have created a package to export from sql 2005 data to DB2 table. In SQL I have nvarchar data type and in DB2 have created field with Vargraphic. The DTS executed successfully but when I did look at the data in DB2, its all square box but there is no proper data. I am using "MS OLEDB for db2" for provider. Could you guys please help me on this. I would really appreciate for your help. Thanks Pkumar.