How to Automatically download csv file from SFTP and upload it to Salesforce using CLI Dataloader, Batch and Window Scheduler ?

So basically the requirement was to automatically download the file from a FTP/SFTP and upload the file in Salesforce Leads. To upload the file we will create a batch and schedule it using Window Scheduler.

To achieve this functionality in short we will create a batch to download the file from FTP/SFTP and save it in our local machine. And then upload it to salesforce Leads using CLI Data Loader.

Please follow below steps :

STEP : A

Download & Install WinSCP on a window machine.

Connect the FTP/SFTP using credentials.

Go to session → Generate session URL/code.

Check only User Name, Password & Initial directory in the case of FTP.

In the case of SFTP check SSH host key checkbox also.

Copy the generated url.

Create a txt file using following code below : 

# Connect

Open URL COPIED FROM STEP 5 

# Change remote directory

cd /

# Download file to the local directory c:\

get fileName.csv c:\TestFolder\

# Disconnect

Close

Save the txt file. My file name is example.txt

Open CMD.

Copy and paste following command  : 

"C:\Program Files (x86)\WinSCP\WinSCP.com" /ini=nul /script=C:\TestFolder\example.txt

Hit enter.
The file will be copied from your FTP/SFTP to your window machine.

STEP : B

First of all, make sure you have the Admin rights on the machine.
Then, download the data loader setup file on the machine by going into Salesforce environment Setup –> Data Management –> Data Loader. Choose the option “Download Data Loader for Windows“. It will download the latest version of data loader setup file. Install it by following the setup wizard.
Also, you need to have the required version of JRE (Java Run Time Environment).