Connecting to MySQL using MSSQL2005 Business Intelligence Studio

[Joel Mansford]

We are migrating from SQL Server 2000 to SQL Server 2005. We use DTS to shift lots of data around and have been able (to a degree) to shift data to/from MySQL using the ODBC Driver.

Now with SQL Server 2005 you get the replacement for DTS which is pretty neat except there are no ODBC connectors anymore! I tried in vain to install the OLE DB .NET provider for MySql but this doesn't show up as a "Native OLE DB" provider when I try to create a new connection manager.

I guess this post may need to be under a development forum, but I thought I'd try you SQL Server guys first!

I could use flat files and scripts but that is a bit too dirty for me and you don't get any progress indications or anything.

Thanks in advance.