September 23, 2019 at 7:29 pm
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.
September 24, 2019 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply