Page 1 of 1

Error while using FTP enterprise stage to read a record

Posted: Wed Jun 14, 2006 11:04 pm
by prindu1302
While I try to FTP a file using FTP enterprise stage from the specified path to my server, the job aborts giving an error that the file name does not exist. But If I create a file in the root directory of the remote server with the same name of the file [not required to be of the same format] and I try to FTP, my job runs successfully and fetches all the records from the remote path specified. Is there any specific setting that has to done?

Posted: Wed Jun 14, 2006 11:55 pm
by ray.wurlod
The URI property is documented as follows.

Type: Pathname
Name of the URI to get or put the file from or to.It can be more than one occurence. Supports limited wild carding. The expected syntax is ftp://hostname[:port]/URIpath


You need to make sure that the URI path points to where your file actually is. If you simply include the file name, it will expect to find the file in the FTP root directory.

Posted: Thu Jun 15, 2006 12:22 am
by prindu1302
I have set the URI followed by the open command where I have specified the remote path.
In the URI I have set the property as below:
ftp://<RemoteServername>/<Filename>
In the open command I have specified the remote path where the file resides as shown below:
cd /<RemotePath>
Do we have to have a file with the same name in the root directory of the remote server for us to ftp the file from the remote server path to our local server?

Posted: Thu Jun 15, 2006 2:05 am
by ray.wurlod
It should not be necessary. The cd command should suffice.

Posted: Thu Jun 15, 2006 3:58 am
by prindu1302
But it is not working if I remove the file from the root directory.Is it like some kind of bug or is it a mistake with the settings that i have done

Posted: Thu Jun 15, 2006 9:21 am
by sud
prindu1302 wrote:But it is not working if I remove the file from the root directory.Is it like some kind of bug or is it a mistake with the settings that i have done
I have used direct path in the location property and it works (cant access DS right now hence cant tell u the exact name of the property). In my case i put a path like /home/<name>/<folder>

Posted: Thu Jun 15, 2006 4:10 pm
by ray.wurlod
sud wrote:I have used direct path in the location property and it works (cant access DS right now hence cant tell u the exact name of the property). In my case i put a path like /home/<name>/<folder>
Was this in an FTP Enterprise stage?