You need first to analyse your table
To see if there anything that can cause problem in sql server (SP, trigger ....)
Then you can use a DTS package
But Remember that Sql server and MySql is a different package
Sql server can do things that MySql can not do