hi 64-bit ODBC client for MySQL driver not support in ssis 2012 (BIDS)version .i tried one more way in
using the MyODBC driver, the configuration UI has an advanced tab for flags. Check "Do not cache result".
Now I got another errore like below
Error:ADO NET Source has failed to acquire the connection {058454B0-D4D6-457A-9E1D-91228BCF947A} with the following error message: "ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'nanikum'@'hadkeld.kumarder.lcl' (using password: YES)
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'nanikum'@'hadkeld.kumarder.lcl (using password: YES)".
-----
Error:DatafromMysql failed validation and returned error code 0xC0208449..
please tell me how to avoid this type of errors in ssis packages.