I'm currently having trouble creating an ADO connection in an MS SQL Server 2005 SSIS package. I need to run an 'Execute SQL Task' in the package. The connection is a MySQL server.
What drivers/software do I need for the ADO connection for MySQL?
Is there any other trick or anything I have to do differently with the SQL for a MySQL database table/query versus a MS SQL Server table/query?