How do I establish a .net provider/mysql data provider connection from BIML code?  When I use the AdoNetConnection connection type, it's asking for a Provider name for MySQL, and it's not accepting MySQL Data Provider.   I am looking for something similar to SQLOLEDB, or MSDASQL - but for MySQL.  I can make this connection from SSIS connection manager UI, and thought anything we can do in SSIS, we should be able to script it out.  Would appreciate any pointers.  Thanks!