SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Contributor SYN
Contributor
Posts: 39

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

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.

Super User
Posts: 5,424

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

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.
Data never sleeps
Contributor SYN
Contributor
Posts: 39

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

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.

Super User
Posts: 5,424

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

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

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 288 views
  • 0 likes
  • 2 in conversation