sql server dts: Hello everybody,

I am new to this concept of DTS and SSIS and I havent worked on
databases before.

I have been trying to migrate frm MYsql to MSSQL 2005 using this SSIS
importn export wizard , but I realised it doesnt recognize the Mysql.as
one of the data sources.

Pls help.
How do I do this migration?

thanks,
Swapnali

Hello Swapnali,

Do you have an OLEDB provider for MySQL?

You may find this helpful

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193071&SiteID=1


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]