FTP into Datastage Server

Bram · Post by **Bram** » Mon Feb 14, 2005 1:33 pm

Hi There,

Is there any automatic way of doing FTP CSV file into Datastage server every week?

Thanks in advance,
Bram

vans2003 · Post by **vans2003** » Mon Feb 14, 2005 2:16 pm

Use FTP Stage to transfer the files from one server to another

You can schedule a job in Datastage director to run weekly...
--Vans

chulett · Post by **chulett** » Mon Feb 14, 2005 2:17 pm

Sure.

Create a shell script to use FTP to get the files you need and run it once a week - either through cron or an enterprise scheduler or as a 'before job' option on a DataStage job that would process them after they arrive.

Or have them ftp'd to your server and use the Wait For File activity in a Sequencer job to poll for them.

Quite a number of different ways to accomplish it, depending on your requirements.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Feb 14, 2005 3:37 pm

Please note that you need to have network connection between the 2 machines. Also check the user and their default ftp root directory.

sun786 · Post by **sun786** » Wed Feb 16, 2005 4:54 am

I think the better way is to write a shell script to FTP the file from source server to the DS server, use that shell as Before job shell. Then schedule the job. You will get the file when ever you run the job.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Feb 16, 2005 4:56 am

But that is exactly what the FTP stage is for.