I am developing a solution that calls an SSIS package from a stored procedure that is called by a trigger. The end result is to push data from a SQL Server db table to a MySQL db table, across servers. Everything works fine when executing the SSIS package locally (either on my computer or on the db server). However, I receive errors when attempting to execute the SSIS package as it is deployed to the catalog on the db server. I suspect that this has something to do with the permissions needed to execute the deployed package. The errors from the execution report are below. I do believe that the connection strings are configured correctly.
Any assistance would be appreciated.