Home Forums Data Warehousing Integration Services MySQL client ran out of memory issue in ssis package. RE: MySQL client ran out of memory issue in ssis package.

  • July 31, 2014 at 12:26 am

    #1733922

    asranantha (7/31/2014)

    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.

    Visual Studio is 32-bit.

    If you want to try out if the memory issue is gone with 64-bit, you need to run the package outside of BIDS.

    Regarding the new error: it seems pretty clear the access is denied. Make sure the correct credentials are passed.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP