Share via

Where can change the protection level of ssis packages besides in SSDT design page?

XB 21 Reputation points
2020-09-23T08:08:14.203+00:00

I have some ssis. dtsx files in the remote server.
The original protection level of the packages have been set as 'EncryptSensitiveWithUserkey'.
But I want to change the protection level as 'Encrypt AllWithPassword' when I execute the package.
How can I realize it?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,612 questions
0 comments
Accepted answer
  1. Monalv-MSFT 5,901 Reputation points
    2020-09-23T08:23:33.983+00:00

    Hi @XB ,

    We can import the packages in MSDB and then change the ProtectionLevel.
    Please refer to the following pictures:
    26586-msdbimportpackage.png
    26892-protectionlevel.png

    Hope the following link will be helpful:
    Change Protection Level for all packages at once

    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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.