Post reply

SQL 2005 DTS giving Junk characters in DB2

  • May 15, 2007 at 2:03 am

    #73191

    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

     

     

     

    Kindest Regards,

    Gopi

  • May 15, 2007 at 9:12 am

    #706536

    I've seen it in the past were the square boxes are the translation of a carriage return/line feed (iether on alone or in combination).

    Regards,
    Matt

  • May 15, 2007 at 7:36 pm

    #706637

    Another thing to check is if SQL is sending unicode data that is not being interpreted properly in DB2.

    If you're seeing a square box as every second character, then this is the case. Unicode uses 2 bytes to represent each character. You'll need to perform a transformation within your SSIS package to convert the data to non-unicode. eg: nvarchar to varchar

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply