Did you install myODBC driver?

Using the "import/export wizard" which is DTS, I found it way too easy, and not a pain in the least.

1) install myODBC driver
2) specify a System DSN aiming at the mySQL database you want to import into MS SQL
3) Run the "Import/Export" wizard.

In seconds, a new MS SQL database is created, with all data transformed and present.

myODBC driver can be downloaded from http://www.mysql.com/

more info available at:

http://www.microsoft.com/technet/tre...vg/miglamp.asp

hth,
Mike