Page 1 of 1

Suggestion on data load using FTP stage

Posted: Mon Jan 10, 2011 1:05 am
by hemaarvind1
Hi,

I have a URI which lists a set of Zip files. I want to move these ZIP files on to a folder in another unix server.

I want to use FTP stage by specifying URI as the source ,but I am not sure of which stage to use as target to move the zip files from URI to the unix folder.

Could you please suggest me the job flow for how to achieve this.

Thank You.

Posted: Mon Jan 10, 2011 6:32 am
by PaulVL
Any particular reason you chose to do this in DataStage?

Is it part of a Sequencer activity that needed coordination?

As for which stage to use, remember that a Command Sequencer can call any command line script you write, and can pass it your variable.

An External Source stage can do that also.

You could set up a script on your source or destination, and trigger that script remotely from your DataStage server or job.

Posted: Mon Jan 10, 2011 8:20 am
by chulett
The FTP stage is metadata driven, works record by record, and thus is not something you can use to transfer a zipped file.

Posted: Wed Jan 12, 2011 3:44 am
by hemaarvind1
Thank You Paul and Chulett for your responses.

Is there any way to transfer a Zip file in Datastage without going for a script?

I have chosen Datastage for this task as I have to do this as part of a Job Sequence.

Please let me know the options of achieving this.

Thank You.

Posted: Wed Jan 12, 2011 4:14 am
by ray.wurlod
You need a script. Use an Execute Command activity to execute the script.

Posted: Wed Jan 12, 2011 4:15 am
by hemaarvind1
Thank You Ray.