Multiples files FTP and Process

[DSRajesh]

Hi All,

I need to ftp the files of type say 1.settlement 2.statements from source server to ds server.

There will be multiple files for each type of files.

Once the all the files are ftped to DS Server,I need to run each file to load into staging tables.

How to implement using ftp script for this.

also how to check if file exists in the remote source folders so that my job runs and pick the files.

If i Have two files of Settlement type with same name for example : HDFC_Settlement.csv,HDFC_09082012.csv..how to process each file in FTP Script.

also need to decrypt the encrypt the files by calling Java Classes through Batch Script.

[ray.wurlod]

There's nothing special about the script - implement it as you would for any other application. Standard FTP techniques/commands are all you need (and maybe a way to handle the password "nicely").