Bring SFT server files to unix server using SAS Data Integration 3.4 Job?

[SYN]

I have one requirement in SAS Data Integration 3.4 Job.

I have some files with prefix XXX_* in SFT mailbox server.

My requirement is to bring these files to unix server using Data Integration 3.4 Job.

Can any one provide me the user written code for this task. Thank you.

[LinusH]

Well, this is not quite the place when you can "order" code.

having that said, you need to clarify a few things:

• What is SFT, and what kind of API_s is available?
• What kind of file are we talking about (mail, attacments, internal mail server)?
• Are these file to be imported to SAS/RDBMS tables? If not, you are probably better off using other tool than DIS.

[SYN]

Yes you are correct.

I am not expecting exact code for this task. Just I need suggestion to bring the files.

SFT means Secure FTP server. It is a internal mailbox server having input/output/sent items.

We need to pickup the files from outbox and put it in unix server. Please suggest.

[LinusH]

Again, if your not planning to import them to SAS tables, I think you're better of doing this using shell scripting.

There is a SFTP access method for the FILENAME statement, but I think that came with 9.2 (and you are in 9.1.3 i believe).