SSIS Package Permissions

• Joel Hatfield

  SSC Rookie

  Points: 46

  More actions

  September 23, 2019 at 7:29 pm

  #3682710

  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.

  

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  September 24, 2019 at 8:10 pm

  #3683075

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.