DSXchange

Hi,
I have used a parameter of Encrypted type, say the value passed to it is "XYZ" and think for a moment that it gets encrypted as "##$%!!" now i want to view this value ""##$%!!" , then how can i do that.

There is no method for viewing the true contents of encrypted columns.

I cannot imagine any scenario where you must view the encrypted value.
It asks you to confirm the encrypted value when you enter default value to make sure there is no typo-error in that.

What else you need and why you want to see that?

I can think of lots of places where I would love to be able to get the unencrypted value of an encrypted parameter; but can't think of a place where I would need to and am pretty happy that the mechanism is secure enough to keep casual programmers such as ourselves from accessing restricted data.

even if there is a way to view that, it should be restricted from being public/ available to casual programmers to keep the mechanism secure.

Dear, do you really wanted to see that value? Is that job param / env var?