Creating ADO Connection in SQL Server SSIS for MySQL

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?

Thanks!
arccosAsked:
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.