
March 25th, 2004, 01:23 AM
|
|
Registered User
|
|
Join Date: Dec 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
FTP file Name Change
I have data files that are uploaded onto my server via FTP, When the files come through, they have a specific name. I would like to change the file name before it is uploaded onto my Oracle DB. I have middleware application that monitors the FTP server for new uploaded files and if there is a file it picks it up and extracts the data onto my Oracle DB. The problem is the Middleware component does not know which table the data is suppose to go into(e.g. Financial, Metering etc). The application works well when I upload thru my website, but I'm not sure how to do it vai FTP.
Example:
Original File Name: ISCOR_DMP_20031025.csv
New File Name: ISCOR_DMP_20031025_DT11-17-2003-8-24-19-AM_FP1_VS0,01.csv
Is there and ASP application that I can write to so that the the file name can be changed as soon as the file is FTP'ed, and before it is picked up by the middlware component.
I would really appreciate any help with regard to the above.
|