• No I used the ODBC version. I just read that I need my source to also use ADO.Net.

    http://dbperf.wordpress.com/2010/07/23/sql-server-integration-services-2008-ssis-and-mysql/

    When I try to map the MYSQL table I have to create one everytime, even when I do create one. I can never remap it again. So I don't see how this package could ever run as an hourly task id this solution only used as a 1 off.