Password info encrypted/clear from Log

nivas · Post by **nivas** » Thu Sep 04, 2008 10:26 am

Hi

In the datastage job I did change the param Type to Encrypted. But in the log we are able to see the actual password. How do I encrypt/clear the password info from the Log.

thanks
Nivas

chulett · Post by **chulett** » Thu Sep 04, 2008 10:28 am

That doesn't make much sense. Can you post the log where you see the actual password? So perhaps we have some clue what is logging it.

nivas · Post by **nivas** » Thu Sep 04, 2008 10:51 am

[runSSISPackageBOALoad2..JobControl (ExecDOS): Executed command: C:\psexec\psexec -u hcf\spari -p abc123 \\HCF15 -i dtexec /SQL \ZeroCouponLoad\BOALoad /SERVER HCF15 /CHECKPOINTING OFF /REPORTING EW
*** Output from command was: ***

The above is the log. I want to encrypt or clear the log .After -p, abc123 is the password. I want to encrypt/clear from log. This password I am passing to the job as encrypted type.

thanks
nivas

chulett · Post by **chulett** » Thu Sep 04, 2008 11:07 am

Ok, the password has to be decrypted before your O/S command can use it. There should be a 'Silent' version of ExecDODS you can switch to that doesn't log that information. If it doesn't exist, it should be easy enough to write one.

umamahes · Post by **umamahes** » Thu Sep 04, 2008 11:12 am

You are executing os command and passing password through command line arguments.Even if you encrypt in data stage it will be displayed in the log.

nivas · Post by **nivas** » Thu Sep 04, 2008 11:27 am

THanks umamahesh for your comment

Chulnet,
Thanks for your help. But unfortunately ExecDODS is not available here. Is there any command to clear the log after the end of the job. Or I may change the strategy.

thanks
Nivas

chulett · Post by **chulett** » Thu Sep 04, 2008 11:30 am

Sorry, typo. ExecDOS which does exist, btw. How are you executing this now - Sequence job? Custom code before/after job?

nivas · Post by **nivas** » Thu Sep 04, 2008 11:44 am

Its a regular datatage job. In the Job control Tab, I put custom code.

thanks
Nivas

nivas · Post by **nivas** » Thu Sep 04, 2008 11:44 am

Its a regular datatage job. In the Job control Tab, I put custom code.

thanks
Nivas

chulett · Post by **chulett** » Thu Sep 04, 2008 11:49 am

Mind posting that code? Did you look to see if there is an ExecDOSSilent available? For UNIX there is an ExecSHSilent, hence the question.

nivas · Post by **nivas** » Thu Sep 04, 2008 11:53 am

Not for us
thanks
Nivas

chulett · Post by **chulett** » Thu Sep 04, 2008 12:06 pm

Then create one. Copy the existing routine and change it so it doesn't log the information you don't want to see in the log.

umamahes · Post by **umamahes** » Thu Sep 04, 2008 12:25 pm

Can you pelase post your code.

nivas · Post by **nivas** » Thu Sep 04, 2008 1:09 pm

chulett wrote:change it so it doesn't log the information you don't want to see in the log. ...

I donot know how to change the code to make to not to log the inform.

thanks
Nivas

nivas · Post by **nivas** » Thu Sep 04, 2008 1:14 pm

chulett wrote:change it so it doesn't log the information you don't want to see in the log. ...

I donot know how to change the code to make, not to log the inform.

thanks
Nivas