I've followed the above steps to achieve the same but when I try to execute that set of T-SQL statements it is throwing the below error:
Msg 229, Level 14, State 5, Procedure create_execution, Line 127
The SELECT permission was denied on the object 'catalog_properties', database 'SSISDB', schema 'catalog'.
Msg 27156, Level 16, State 1, Procedure create_execution, Line 131
The Integration Services server property, 'ENCRYPTION_ALGORITHM', cannot be found. Check the name of the property and try again.
Msg 27146, Level 16, State 1, Procedure create_execution, Line 178
Cannot access the package or the package does not exist. Verify that the package exists and that the user has permissions to it.
Please let me know if I am missing anything.