SSIS fails in Integration Services Catalog

The SSIS package is Deployed in Integration Services catalog and a SQL Agent Job is created. The Job Fails giving the error - 'Could not create a managed connection manager', But the SSIS runs fine in BIDS. I changes the User from Service Account to SSIS proxy too - both didn't work

I have used a ADO.NET connection to connect to MYSQL database.

Can you please suggest?

Also I tried changing the ADO.NET source and connection to ODBC connection and SOurce. But still I get the below error,

Load data from MYSQL to Scratch:Error: The managed pipeline component "Microsoft.SSISODBCSrc" could not be loaded. The exception was: Could not load type 'Microsoft.SSISODBCSrc' from assembly 'Microsoft.SqlServer.PipelineHost, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.. Load data from MYSQL to Scratch:Error: Component ODBC Source, clsid {4F885D04-B578-47B7-94A0-DE9C7DA25EE2} failed to initialize due to error 0x80131600 Load data from MYSQL to Scratch:Error: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "ODBC Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1". Load data from MYSQL to Scratch:Error: The component metadata for "ODBC Source" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. Load from MYSQL to Scratch:Error: ADO NET Source has failed to acquire the connection {E787C40A-C88A-4F03-8A03-BC257C13CCDD} with the following error message: "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

Thanks in advance.