I have an SSIS package which I built in VS 2022 then deployed locally to a SQL Server 2019 instance.

I pass the connection strings for both source and destination databases as parameters in the parent package, which then bind to parameters in the child packages, this works fine when both the source and destination databases are on the local instance. As soon as I change the parameter to point to a different server/db, it fails and says the parameter is incorrect. I know the details are correct as I can log on with them, does anything obvious look wrong with this?

Data Source=tcp:mysite.database.windows.net,1111;Initial Catalog=MyBd;Provider=SQLNCLI11;User ID=MyUser;Password=mypass123;Auto Translate=false;