How to import data to mysql db?

I need to import data to mysql,

and idea abt that?

thanks

SSIS does not have an ODBC destination for MySQL, but you can write one with very few lines of code (see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=106559&SiteID=1)

If you'd rather use third-party tools, this might be helpful http://www.webyog.com/en/sqlyog_migration_toolkit.php

Be wary of common pitfalls around types (e.g. SQL Server's VARCHAR data type can hold up to 4,000 characters, while MySQL's VARCHAR can only hold up to 255 characters).

|||MySQL has an ODBC connector which CAN be used with the DataReader Source though.