Don't think so. The customer would be  100 miles around the block and the solution and data itself only existed on the customers server.

No other option than to set...

Yes, of course.

In fact I would say that you've been going against best practice for those 15 years.

Developing locally with VS and SQL Server and then checking in your changes...

We do need some more information here.

While you have provided your desired output, can you also provide the input data corresponding with that desired output, so that someone here can...

I don't know how much it matters, because I always make sure my version of VS is at least as high as the version of SQL Server I am deploying...

Are you editing the SSIS project in VS2022?

Have you set TargetServerVersion to SQL Server 2022 in the project's properties?

Have you taken the 'Upgrade All Packages' option to make sure they're...

There might be some fair overhead to getting the current length of a text column.  If you really have to have that, add a column to the table to...

Is this a blog post, or do you have a question?

It's available to...

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.