Once again, if you want coding assistance, please provide consumable sample data for us to experiment with.

This semi-join version of the UPDATE might perform better

UPDATE pt
SET LastModifiedDateTime = @dt
FROM PlayersTypes pt
WHERE EXISTS
(
    SELECT 1
    FROM @TableTypePlayersTypes ttpt
...

First you check whether the table has data. Then you obtain the...

Are you sure that this will improve performance? It's going to introduce a lot of code 'waffle', which looks inelegant to me.

Please provide your sample data in the form of CREATE TABLE/INSERT statements and also provide your desired results.

As far as I can remember, Windows...

Redgate Clone, perhaps? (Link)

Having Access run a stored proc to execute a package deployed to SSISDB is the way to go. Any other way is likely to violate software licensing.

If you don't currently...

OK, good. So what is it that you are not able to do, exactly?

If you change the protection level to Don't Save Sensitive and try deploying again, the error should go away.

However, the values of any params marked as sensitive will not be...

In VS2022, if you go to Extensions/Installed/All, do you see the following?

'SQL Server Integration Services Projects 2022'

Can you provide the exact error message?

What is the Protection Level of the SSIS project? (Under Project/Properties)

Please expand your sample data to include some values with embedded commas, so that I can assess whether the existing code can be refined to handle them. Thank you.

Note that...

Thanks.  This looks good.  Haddnt stumbled on split_string

When i run code on my machine it returns?

Msg 8144, Level 16, State 3, Line 27 Procedure or function string_split has too...

... future? 😀