SSIS transfer failure from mySQL to SQL Server 2005 table

  • Hi - the column that is causing the error is a very simple text field from a mySQL database.

    It is a varchar(80) field. The error I'm getting is "Unicode data is odd byte size for column 29. Should be even byte size.".

    Via conversion transformation the field is mapping to a unicode [DT_WSTR] string with a length of 80 (I did try giving it more length when I ran out of other things to try).

    I'd appreciate any information on how to overcome that error in addition to any help in locating SSIS documentation that would indicate how to handle some of these conversion issues. thanks a lot.

  • This was removed by the editor as SPAM

  • thanks for the insight. I'll see if i can filter out the bad data.

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

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