Truncated Data

[Fred]

Data truncation: Out of range value adjusted for column 'LeadsRating' at row 3
86 row(s) transfered.

Has anyone seen this message and what does this error mean / how is it corrected?


I am attempting to migrate a MS SQL Server 2000 DB (Development Version) to
MySQL 5.0 using the MySQL Migration Toolkit (Winows XP). Several of the tables
are empty after the process is complete.

In each case the message is as follows with specific references to the table and
column. The column data type in question looks to be floating point in SQL Server
and no mapping errors are given during the migration process. In the case of this
table the message indicates that 86 rows were transfered, but zero rows actually
were transfered.

`E-T_LeadsApp_dbo`.`ET_Leads_Data_Import`
-----------------------------------------
Data truncation: Out of range value adjusted for column 'LeadsRating' at row 3
86 row(s) transfered.


(I have confirmed that the erroneous reporting that the data was transfered appears to be a bug.)