User Variable Activity log

[partheev123]

Hi all,


In my requirement I need to pull sqlquery,username and password from a table and pass them as parameters to the next job.

So for that I landed the sqlquery and credentials in a sqlfile. Using server routine I parsed them and passed to the next job with user
variable activity.

This flow works fine but in the log of uservariable activity we see all the information like password,username and sqlquery. Is there any way we can hide the password details?

[anbu]

Make the password job parameter as encrypted type in the job

[partheev123]

[quote="anbu"]Make the password job parameter as encrypted type in the job[/quote]

Hi anbu,

Thanks for the quick response :)

Actually using User Variable Activity I am passing the password as parameter to the nextjob where I made it as encrypted. But when I see the log of the sequence, for user variable activity it shows the password.

[anbu]

I dont see log for user variables activity in any of my jobs.

If the variables you created are used only once in a job then call the server routine directly in job activity instead of using user variable activity

[partheev123]

[quote="anbu"]I dont see log for user variables activity in any of my jobs.

If the variables you created are used only once in a job then call the server routine directly in job activity instead of using user variable activity[/quote]

Hi anbu,

Thanks for the suggestion. My issue got resolved :D
Acutally the log is from server routine not from uservariable activity.
In the routine DSLogInfo is giving the log details(sqlquery,password,usrname)

Thanks again