Almost there by following
http://www.packtpub.com/article/mysql-data-transfer-using-sql-server-integration-services-ssis
I can get the data to MYSQL but in have to create a table when creating the SSIS package. It doesn't recognise any of the existing MYsql tables and will not populate them in a drop box.
I want to transfer data to an existing table is it possible?