This is more obscure than I thought.

The problem appears to only apply to one database in the instance.

The rest can be accessed ok remotely?

So opened the package and changed the setting (having finally found it) to use EncryptSensitiveWithPassword. The package executes ok now through the Execute Package Utility, but pending confirm as...

So how would I go about changing it (or correcting it or removing the requirement)) ?

After a bit of digging, I think I have found the answer. (at least to what was causing me problems!)

Three of the input parameters are numbers (INT) but trying to...