DSXchange

Hi,

I need to ftp files from a different server. The conventional method is obviously to be using scp/ftp from the command line. but my requirement is to be able to accomplish this using the FTP stage in DS. The source files are not normal text files - they are encrypted. To my understanding, while using the FTP stage (for "getting" file from a diff server), I need to specify the schema of the target file. But in case, it is encrypted, I wouldnt be able to do so. Is there any other mechanism by which I can perform the task without having the Datastage to parse through the file?

THanks,
Sriram

Use a dummy schema. You can declare the file to be FTP'd as having one column with fixed length and no line terminators. Write what you've transferred with same settings into a file and you've completed, in a very roundabout way compared with a straight binary FTP command-line, a binary FTP from DataStage.

I would highly recommend changing your requirements.

Stick with command line file transfer utilities for things of that nature.

The FTP stage types do not FTP files. They transfer file contents directly into the job design.

ray.wurlod wrote:The FTP stage types do not FTP files. They transfer file contents directly into the job design. ...

So it meas Ray we can't use this stage to transfer file from one server to other?

No, that is not what Ray or I said. As written earlier, you transfer data to your DataStage job via the FTP stage then write a file from the job.

ArndW wrote:No, that is not what Ray or I said. As written earlier, you transfer data to your DataStage job via the FTP stage then write a file from the job. ...

IT means not directly to file on other server.

Thanks a lot for explanation Arnd!!!!