[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