Thom A (12/5/2016)
Thats not what I was saying, you need to escape the special charaters:
exec xp_cmdshell 'dtexec.exe /F "D:\DBUpdates\Mypackage.dtsx" /SET "\package.Variables[User::JobLoginPassword].Value";"8\:\;xLuZc"'
Many thanks for the clarification, but again after trying several dozen combinations with the \ before and after the special characters still getting the same error! Very surprised it did not work.
...