Using Flat File as a source, located on Remote Unix Server
588645Oct 25 2007 — edited Feb 25 2008Hello
I am trying to load a data from a flat file to a table.The flat file is located on a remote unix server.The OWB 10gR2 repository is also on the same server.
While creating the flat file module in local OWB Client,I am specifying the unix path of the flat file(/users/batchusr/data/input). I am creating the flat file structure by right clicking the flat file module and selecting NEW.The flat file has same structure as the file located on server.I am doing this because I will not be able to import that file file.
When I deploy the mapping ,the control file is being created in local itself.It is creating the folder structure in my local as C:\users\batchusr\data\input.The error message that I am getting is as follows
SQL*Loader-500: Unable to open file (/users/batchusr/data/input/DEA_to_BIS_unload_Without HDRTRL.dat)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Is it the correct way to do it?
Thanks in advance for the suggestions.
Regards
Avanish