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?
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.
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. ...