On my laptop I have MS SQL 2000 running next to MySQL. I have MyODBC installed to convert data from SQL2K with DTS. Most tables convert without a problem, but some not. Take this table:

- id (decimal 18,0 not null)
- name (varchar 50 null)
- order (decimal 18,0 null)
- value (decimal 18,0 null)
- deleted (char 1 null)

If I let DTS convert this table, the table is created succesfully. The types and names are the same in MySQL, but it doesn't work.

I get the error message from DTS: Error at Destination for Row number 1. Errors encountered so far in this task: 1.

So I've copied all data by hand for the first row (using MySQL Front), and no problem there. Then I've used DTS again, but left out one column at a time. It turned out that if I left "order" out, the table was converted normally. If I convert only the order-column, I get the same error. If I look at the data of the order-column, it's just numbers between 1 and 40. I've changed the numbers to all 0, but that didn't change anything. The strange thing is that the value- and id-columns have the same data type but no problems.

I have similar problems with other tables, with a float (SQL2K) to double (MySQL), and a varchar 500 to text conversion. Any ideas what causes this problem?