DSXchange

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,

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

for example in windows

put the file name tab of sequential file stage as

\\<remoteserver>\source\input.txt

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,

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,

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

Thanks in advance,

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

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

Thanks in advance,

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.

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

Thanks,

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

Regards
Sreeni

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'.

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,

gssr wrote: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!

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,