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

Question

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?

Answer 1

Hi @XB ,

We can import the packages in MSDB and then change the ProtectionLevel.
Please refer to the following pictures:

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.