MySQL Forums
Forum List  »  Microsoft SQL Server

TEXT field issue
Posted by: Matt Jenneson
Date: October 05, 2007 04:05AM

Hello all,

I'm trying to export from MSSQL to MYSQL using DTS. Everything works fine except for large text fields.

I have played around with changing the type of field in MSSQL to varchar rather than text, the dts fails unless i change the field in MYSQL to varchar, but 255 is not enough.

Think it might be a problem with the ODBC.

Does that make sense to anyone? any ideas?


Edited 1 time(s). Last edit at 10/05/2007 05:41AM by Matt Jenneson.

Options: ReplyQuote

Written By
TEXT field issue
October 05, 2007 04:05AM
October 05, 2007 05:47AM
October 09, 2007 07:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.