How to preserve customizations made to views in the 'catalog' schema?

Question

In order to suppress sensitive variables from appearing in the Integration Services Catalogs' execution reports, we have made alterations to views in the 'catalog' schema of the SSIS DB.

These customizations are overwritten when SQL Server patches are applied. Is there a way to persist these customizations so that altering the views are not a necessary post-patch step?

Answer 1

Caveat: I don't work with SSIS, and I have no particular experience of SSISDB. I only speak from common sense.

You have already trodden on to the path of unsupported actions. Maybe you can achieve what you want with help of some DDL trigger, but you would be walking more steps on that path into the wilderness. Right now, you have only one foot on the path, but the further you walk, the bigger the risk that you will not find your way back.

So I would recommend that you stay with what you do now.

Answer 2

Hi @Fitts, Keith (EOL),

Is it possible to use indexed views?