How to run .bat file through windows scheduler with ADS

Question

0.00/5 (No votes)

See more:

Hi,

We have a functionality where in we are transferring the .csv files to remote SFTP server using batch (.bat file on windows) file. Batch file uses WinSCP and passes username and password (in clear text). We have scheduled this file using windows scheduler and it works fine. Till here there is no issue.

But we have a requirement to either hide or encrypt the password that we are passing in clear text. For this we tried with Alternate Data Stream concept where we are storing the password in ADS and then retrieving this password using another batch file in main batch file which transfers the file to remote SFTP. If we are manually calling the batch file the password to main batch file is provided and file transfer is successful to remote SFTP. Till here we have achieved hiding of password and file transfer.

But while scheduling the main batch file through windows scheduler, the password doesn't get retrieved in main batch file and file transfer fails. Please let us know if there is any way to achieve this.

ADS

What I have tried:

Posted 29-Mar-19 0:47am

SNI

Updated 29-Mar-19 1:52am

Add a Solution

Comments

SNI 29-Mar-19 6:50am

forgot to provide ADS url
http://scripts.dragon-it.co.uk/scripts.nsf/MainFrame?OpenFrameSet&Frame=East&Src=%2Fscripts.nsf%2Fdocs%2Fbatch-password1!OpenDocument%26AutoFramed

Richard MacCutchan 29-Mar-19 7:21am

Why not ask the people at Dragon?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2019-03-29T01:52:00

Create an executable with the encrypted password stored in a variable. Have the executable run sftp instead of using the batch file.

If you need to change the filename every once in a while, that can be accomplished via an app.config file, or you can simply put the file to be transferred in a location known by the application, which can then use the FileSystemWatcher object to determine when a new/changed file is in the folder.