DSXchange

Hi There,


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


Thanks in advance,
Bram

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

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

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.

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

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.

But that is exactly what the FTP stage is for.