Multiples files FTP and Process
Posted: Wed Aug 08, 2012 5:44 pm
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.
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.