Unable to use password from orchestrator asset into database connection string



I am tryng to connect to Oracle database using OLEDB. In the connection string, i am providing the .ToString but it throws an error “Logon failure: unknown user name or bad password”. How do I get around it? If I use the native GetPassword activity, it clears out once I publish the code. So cant use that too. Please help…!


GetPassword activity returns a SecureString, but the Connection String field only accepts Strings, so you have to convert the SecureString to String