Upgrading SQL Server 2000 to MySQL 5.1 using DTS - How solve DateTime problem? -

I am trying to migrate to MySQL using DST from STL Server 2000. This is the best tool I still know.

But there is a column with a time table type in a SQL Server tables, DTS suggests the following SQL code:

  'Varsha' long Varbinary NULL, 'End date' long unlimited faucet,  

should be:

  date of start date, 'expiration date' date time zero ,  

I make changes manually but DTS does not accept new scripts. IT says:

0x800040e14 HR result returned unexpected error. An error result was returned without an error message.

I have already solved the problem.

I followed the steps:

1. Changing the suggested script changes Varbinary to datetime for a long time
2. Any potential Do not worry about the warning message which
3. this change will not reflect in the list of destination columns that still display the long type of barbows
4. Go to Transformations, Check that there are distinction relationships in the column

if If E also has a problem, try:

1. On the Transformation, click New
2. Follow the instructions that provide all the information about the column and the relationships you make

This is the way thanks anyway!