Suggestion on data load using FTP stage

hemaarvind1 · Post by **hemaarvind1** » Mon Jan 10, 2011 1:05 am

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.

PaulVL · Post by **PaulVL** » Mon Jan 10, 2011 6:32 am

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.

chulett · Post by **chulett** » Mon Jan 10, 2011 8:20 am

The FTP stage is metadata driven, works record by record, and thus is not something you can use to transfer a zipped file.

hemaarvind1 · Post by **hemaarvind1** » Wed Jan 12, 2011 3:44 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 12, 2011 4:14 am

You need a script. Use an Execute Command activity to execute the script.

hemaarvind1 · Post by **hemaarvind1** » Wed Jan 12, 2011 4:15 am

Thank You Ray.