Uploading csv files with different names on periodical basis. [message #661223] |
Sat, 11 March 2017 02:49 |
Manoj.Gupta.91
Messages: 239 Registered: March 2008 Location: Delhi
|
Senior Member |
|
|
Hi All,
I've a scenario where we receive files on clients FTP on every 30 minutes. We need to download these files from there and upload it's data to database tables.
Downloading is done by Java code at present. I want to know the correct approach to upload their data to database tables as the file naming convention is FILENAME_DDMMYYYY_HH24MISS.csv
Every time we receive file the name will be different. Although I can create external table for the same and alter LOCATION parameter before uploading file's data to database.
I just wanted to know is there any other better approach to achieve this?
Thanks & Regards
Manoj
|
|
|
|
|
|