Need to get file from another Server

[gssr]

Hi ,
I have an rar file on another server. As it was a huge file of 3GB, i cant move it to the DS server, IS there any option in Datastage to fetch a file from another server. The File is in TXT format.

Please Suggest me a solution.
Thanks in Advance,

[Sainath.Srinivasan]

Yes. If you can make that server path visible from your DataStage server.

[sajidkp]

for example in windows

put the file name tab of sequential file stage as

\\<remoteserver>\source\input.txt

[gssr]

How to imply that in sequential stage
I am having the file in the Client machine,
How can call the Source TEXT file from the DS server

Thank you for your replies,

[gssr]

I tried this in Sequential Stage input page,

\\10.4.10.12\FileServer\mkr\Development_Projects\RMK\Final\Final_Query2.txt:

,but it throughs me an error of ,

Unable to open \\10.4.10.12\FileServer\mkr\Development_Projects\RMK\Final\Final_Query2.txt:
No such file or directory.

Thanks,

[gssr]

Can we use a compressed RAR file as source in Seqential stage,
If yes, how can i load the table defenitions,

Thanks in advance,

[naveen.p]

You can use a FTP Plug in to read the data from the other server.

[gssr]

Can you elaborate that Stage, since i have not used it before

Thanks in advance,

[naveen.p]

I too haven't used that stage.

Like the Sequential File stage, the FTP Plug-in stage extracts data from, or writes data to, a single text file. However, the text files to be accessed by FTP Plug-in reside on another machine (possibly with a different file system and character file storage conventions) over a communications network instead of on a local disk.
FTP Plug-in provides users with rapid and efficient remote file access using
existing FTP servers on remote platforms. FTP Plug-in does not require additional installation on the remote platforms.

You can search for the pdf document of the FTP Plugin Stage from google.

[gssr]

Can anyone guide me in using the FTP Plugin Satge!!

Thanks,

[Sreenivasulu]

Use the help manual and come back with queries
I think no one will guide you in this forum

Regards
Sreeni

[chulett]

People will be happy to 'guide' if you have specific questions but no-one is going to type up a complete lesson, for that there's the documentation and Help button inside the stage.

However, you will not be able to use the FTP stage with anything that's not a plain old sequential file - i.e. no RAR files or 'compressed archives'. You can use the filter option in the Sequential File stage if your archive supports the notion of 'uncompressing to standard output'.

[gssr]

Thank you all,
I gone through the manual and i searched in DSX for the FTP plugin details,
I tried to work through it,
Now i have some queries,
Can i connect to the local machine i.e.,Localhost,?
If so, What is the properties that has to be set as mandatory?
I am having a 3GB file in my desktop of the local machine..

Thank you once again,

[syeed]

Thank you all,
I gone through the manual and i searched in DSX for the FTP plugin details,
I tried to work through it,
Now i have some queries,
Can i connect to the local machine i.e.,Localhost,?
If so, What is the properties that has to be set as mandatory?
I am having a 3GB file in my desktop of the local machine..

Thank you once again,

Hi,

I had a similar situation, I feel your local machine is a Windows machine, if yes, then, first you need to enable FTP service on your local machine (for this you can contact your System Admin).

FTP-Stage is a very simple stage, you need to provide MachineName UserID, Password, Path and file name.

Thanks!

[gssr]

Yes Syeed, My local machine is Windows. Can you tell me how to check the status of the FTP Service in my local machine

Thanks,