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!
