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,407 questions
0 comments No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,891 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