SSIS Package Permissions

  • Joel Hatfield

    SSC Rookie

    Points: 46

    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: 80380

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply