SSIS execute sql task fails with "parameter name is not recognized" against Azure SQL MI database but works fine against on-prem database,

I have on-prem SSIS package with execute SQL task. Execute SQL task has been runnning without any issue with following parameter mapping when executing against on-prem SQL 2019 database.

On-prem parameter mapping
Variable Name  –   User::UserName
Direction      –   Input
Data Type      –   VARCHAR
Parameter Name –   NewParamterName
Parameter Size –   0

However, When i run the same execute sql task with the same parameter mapping against Azure SQL MI database then it fails with "parameter name is not recognized". SSIS execute sql task fails with following parameter mapping executing against Azure SQL MI database.

Variable Name  –   User::UserName
Direction      –   Input
Data Type      –   VARCHAR
Parameter Name –   NewParamterName
Parameter Size –   0

SSIS execute SQL task runs fine with following parameter mapping executing against Azure SQL MI database.

Variable Name  –   User::UserName
Direction      –   Input
Data Type      –   VARCHAR
Parameter Name –   0
Parameter Size –   -1

Why would execute sql task in on-prem ssis will fail with "parameter name is not recognized" against Azure SQL MI database but runs fine against on-prem database?