ConnectionString for SQL based Custom Target System

Question

We've created scripts that provision changes to Target System. Now we're defining ConnectionString inside script: 
 Public Function CCC_Function_Name(args) As Boolean

 Dim sqlConnectionString As String = "Server=192.168.1.10;Database=test;User ID=idm;Password=P@$$w0rd"
 
 ...

End Function 
 As You can see password is plain text. What is the best practice to pass encrypted ConnectionString to Process Step and where it should be stored i.e. UNSRootB?

Barry Jackson · Answer

Hi, 
 
This is what I have done in the past ..... not necessarily best practice but it works within the framework of the product ...... 
 
Create a custom config parm that will hold the value of the connection string ..... mark it as encrypted ..... be careful because as soon as you click away the value will be encrypted immediately! 
 
Now add a parameter to your script args that will take the connection string. 
 
In your job step that calls the script set the value of the parameter to the value of the custom config parm ..... mark the the job step parameter as hidden and encrypted. 
 
Now when the job runs it will decrypt the config parm on the fly and pass it to the script .... but it will not be shown. 
 
HTH, Barry.