Reading a csv file directly from a Shared drive location
Posted: Wed Sep 05, 2012 11:55 am
Hello,
I have a need to read a ".csv" file, which is placed on a shared drive location (path not yet determined ... but for now, I have it on my work station) and load it into a table. This process is on demand.
As I see it, I can do this two ways ... 1) FTP/SCP the file to IIS Unix box and then run a job to load it into the table or ... 2) Read it directly from that location, because there will be versions of this file in that directory, and load the table. I would like to go with option 2, but I am unable to figure out how to do it.
I tried Data Direct ODBC driver for Text files to read the file, but it is not possible to connect to the file. I am obviously missing something here, and would appreciate it if somebody could point me to the solution.
Thanks in advance.
I have a need to read a ".csv" file, which is placed on a shared drive location (path not yet determined ... but for now, I have it on my work station) and load it into a table. This process is on demand.
As I see it, I can do this two ways ... 1) FTP/SCP the file to IIS Unix box and then run a job to load it into the table or ... 2) Read it directly from that location, because there will be versions of this file in that directory, and load the table. I would like to go with option 2, but I am unable to figure out how to do it.
I tried Data Direct ODBC driver for Text files to read the file, but it is not possible to connect to the file. I am obviously missing something here, and would appreciate it if somebody could point me to the solution.
Thanks in advance.