insert text field from MSSQL to MYSQL failed

Question

I'm trying to income data from a MSSQL (2005) table to MYSQL (5) table, using SSIS, all fields insert correctly. Except one field that his type is TEXT in MSSQL to MYSQL TEXT field, and always this field is get NULL !

Answer 1

How large is your text field in SQL Server 2005? The basic TEXT field in MySQL has a limit of 65,000 bytes so anything larger than that will be lost and SSIS isn't that hot at letting you know when this is happening. Did you try changing the destination field to MEDIUMTEXT or LONGTEXT?

Also, if that doesn't work you could always try to output the values you are trying to insert into the MySQL 5 table before you actually insert them to see if they are being padded with spaces or something else odd is happening.

Answer 2

Make sure the text encoding is the same for MySQL as it is for MSSQL.