just to understand.
What type of object / script is this ? NSH, BLPackage,....?
And the password is stored in a property of Type "Encrypted String" ?
I've found that Jython handles passwords much better than native NSH, if that's an option for you.
Steffen, John, Thank you for the responses, I am getting this second hand so am trying to make sense of it myself, I will get the answers to the questions or better still get my colleague to respond to this thread.
From what I understand I believe its a BLpackage that is generating an SQL script, the frustrating thing is if you run it locally on the server either via the command line or via powershell the password is not getting interpreted, I am trying to find out exactly what shell he is running this in. And will respond.
Appologies for not being able to provide the full infomation straight away.
I think this is going to be an issue w/ the shell you are running this in more than anything as others have mentioned.