[thelist] DTS transfer from SQL Server into mySQL text field

Mark Rees mrees at itsagoodprice.com
Thu Oct 27 10:05:42 CDT 2005


Hello

I'm using DTS with ODBC 3.51 to send data from MSSQL Server 2000 into mySQL.
Everything is working fine, but I am struggling with mySQL destination
fields of type text and mediumtext.

If I try to insert the contents of a MSSQL text or VARCHAR column directly,
the DTS job fails
If I try to insert a string like 'teststring', the DTS job does not fail,
but the destination field contains NULL

If I try to insert directly on the mySQL box using mySQL Control Center, I
do not have any problems

Has anyone seen this behaviour before?

Thanks in advance

Mark
www.itsagoodprice.com - top-brand electronics for less.





More information about the thelist mailing list