topic Re: Bring SFT server files to unix server using SAS Data Integration 3.4 Job? in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129126#M1699 <HTML><HEAD></HEAD><BODY><P>Well, this is not quite the place when you can "order" code.</P><P>having that said, you need to clarify a few things:</P><UL><LI>What is SFT, and what kind of API_s is available?</LI><LI>What kind of file are we talking about (mail, attacments, internal mail server)?</LI><LI>Are these file to be imported to SAS/RDBMS tables? If not, you are probably better off using other tool than DIS.</LI></UL></BODY></HTML> Wed, 30 May 2012 10:49:13 GMT LinusH 2012-05-30T10:49:13Z Bring SFT server files to unix server using SAS Data Integration 3.4 Job? https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129125#M1698 <HTML><HEAD></HEAD><BODY><P>I have one requirement in SAS Data Integration 3.4 Job.</P><P>I have some files with prefix XXX_* in SFT mailbox server.</P><P></P><P>My requirement is to bring these files to unix server using Data Integration 3.4 Job.</P><P>Can any one provide me the user written code for this task. Thank you.</P></BODY></HTML> Wed, 30 May 2012 09:24:41 GMT https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129125#M1698 SYN 2012-05-30T09:24:41Z Re: Bring SFT server files to unix server using SAS Data Integration 3.4 Job? https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129126#M1699 <HTML><HEAD></HEAD><BODY><P>Well, this is not quite the place when you can "order" code.</P><P>having that said, you need to clarify a few things:</P><UL><LI>What is SFT, and what kind of API_s is available?</LI><LI>What kind of file are we talking about (mail, attacments, internal mail server)?</LI><LI>Are these file to be imported to SAS/RDBMS tables? If not, you are probably better off using other tool than DIS.</LI></UL></BODY></HTML> Wed, 30 May 2012 10:49:13 GMT https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129126#M1699 LinusH 2012-05-30T10:49:13Z Re: Bring SFT server files to unix server using SAS Data Integration 3.4 Job? https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129127#M1700 <HTML><HEAD></HEAD><BODY><P>Yes you are correct.</P><P>I am not expecting exact code for this task. Just I need suggestion to bring the files.</P><P>SFT means Secure FTP server. It is a internal mailbox server having input/output/sent items.</P><P></P><P>We need to pickup the files from outbox and put it in unix server. Please suggest.</P></BODY></HTML> Wed, 30 May 2012 11:31:47 GMT https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129127#M1700 SYN 2012-05-30T11:31:47Z Re: Bring SFT server files to unix server using SAS Data Integration 3.4 Job? https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129128#M1701 <HTML><HEAD></HEAD><BODY><P>Again, if your not planning to import them to SAS tables, I think you're better of doing this using shell scripting.</P><P>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).</P></BODY></HTML> Wed, 30 May 2012 13:00:22 GMT https://communities.sas.com/t5/SAS-Data-Management/Bring-SFT-server-files-to-unix-server-using-SAS-Data-Integration/m-p/129128#M1701 LinusH 2012-05-30T13:00:22Z