Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server running your SSIS package to the server running MySQL should be necessary to allow.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato