I have odbc connector installed (.net msi executable from web) and then created a dsn to mysql..

everything else works fine

my task is to fire sql code from sql server on to mysql database

logic will be

check if the table exists

if no then create the table

and then insert into the table select from sqlserver.dbo.table

I am looking into SSIS now with Script task...but doesnt look like its going to be starighforward plz advise