I would propose using the OLE DB provider version. It is reusable, i.e. the connection could then be made using an OLE DB destination, with the provider as the relevant MySQL Data provider. All destination tables et al are then visible and available for selection and mapping. The package can then be scheduled for regular execution.