In my package I am calling one exe to copy the files from local folders to SFTP. I am using a execute process task and I am passing the parameters like (address, username, password,....). The exe and syntax are given below.
SFTPCopier.exe <<machinename>> <<username>> <<password> <<local directory path>>
The problem is when the exe is failing to copy the files to SFTP due to some reason, the SSIS package is outputting the entire command in the log information (including the username & password).
I dont want to write the password in the log information. I want to remove that password from the log information when an error occured in the execute process task.
Can some one please tell me the way to override the message?
Can I put a on error handler for that execute process task and use a script task to modify the "ErrorDescription" variable? Will that works?
Thanks in advance.
View Complete Post