Drew's suggestion is the way forward. Here is an article which demonstrates the technique:

https://www.sqlservercentral.com/articles/the-output-clause-for-update-statements

Set Trust Server Certificate to true to jump...

True, I think...

True, I think...

When I connect to 2022 databases on an Azure VM, I use the MSOLEDB provider, because I had trouble connecting with Native Client. Maybe you could try that.

Yes,  that's the way.

When you say 'the catalog is there', what do you mean? SSISDB is the catalogue. The action of creating the catalog creates SSISDB.

First of all you talk of having no Id or password, but then you all about updating a password. Which one is it?

That is what I was suggesting. I also use SSISDB environment variables to override environment-specific items. But if the settings are the same regardless of environment (eg, the name of...

Not quite what I asked, but good enough!

I'm wondering why the source of that message is 'Transact SQL Stored Procedure' and not from the connection manager, but I'm not sure...

Seems like a reasonable error message...

Possibly because of this row:

and bk.backup_finish_date < getdate()- 1;" -ServerInstance "ABC" -Database "db"

Try changing it to

and bk.backup_finish_date < getdate()- 1;" -ServerInstance $ServerName -Database "db"

Out of interest, David, when hiring fresh out of college, did you filter depending on what they'd studied, or did you keep things completely open?

Do you have the same version of SQL Server on your machine and on the server?

> And trying to teach a subject-matter expert how to 'do' IT is equivalent to teaching an actor how to dance.

MMM... usually, but not always.  I'd love to have...