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?
User Variable Activity log
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 20
- Joined: Sun Dec 20, 2009 10:46 pm
-
- Premium Member
- Posts: 20
- Joined: Sun Dec 20, 2009 10:46 pm
[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.
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.
-
- Premium Member
- Posts: 20
- Joined: Sun Dec 20, 2009 10:46 pm
[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
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