A couple of resources to get you started:

Stairway to Integration Services[/url]

Connecting to MySQL from SSIS. I haven't had to connect to MySQL but it appears that this blog post as well as some of the comments following could be useful.