ssis permissions

NeophyteSQL 241 Reputation points
2020-09-21T22:17:59.34+00:00

what minimal permissions are needed to deploy ssis packages to the catalog database.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,504 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2020-09-22T01:15:17.567+00:00

    Hi @NeophyteSQL ,

    1.If you change the SSIS service account from the default, you may have to give additional permissions to the non-default service account before you can deploy packages successfully. If the non-default service account doesn't have the required permissions, you may see the following error message.

    2.We can also set a protection level that helps protect just sensitive data or all the data in the package.

    Please refer to the following links:

    (1)Permissions Required to Deploy SSIS Projects and Packages

    (2)Access Control for Sensitive Data in Packages

    Best Regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.