Hello ,
During transformation of data from sql server 2000 to Mysql using DTS
import/export wizard( using mysql odbc 3.51 driver & file dsn).I
encountered the following error:
Error at Destination for row number 1.Errors encountered so far in
this task:1
Insert error,Column 2('ANAME',DBTYPE_STR),status 6:Data overflow.
Insert error,Column 1('ACODE',DBTYPE_STR),status 6:Data overflow.
Multiple-step OLE DB operation generated error.Check OLE DB status
value,if available.
The table structure in SQL and the corresponding table in MySQL are
listed below :
sql server 2000 Mysql alpha version 5.0.0
Source table Destination table
name datatype length name datatype length
ACODE char 10 ACODE varchar 10
ANAME varchar 50 ANAME varchar 50
Could some one please help me in pointing out what am i doing wrong ?
The operating system is Win2k
Thanks in Advance
Jim Nowick