DTS Reading file from Unix

[Pattycake245]

Is it possible for a DTS package to read a text file from a Unix server? Right now I am reading it in from a windows directory.

thanks, Tim

 

[mrdenny]

Yes, but it will take some setup. You have a few options availble to you.

1. You can install Samba on the Unix box so that the windows machine can read the file directly from the Unix box just like it's a windows server.

2. You can install Sygwin on the Windows box (a unix emulator) and set it up to ssh over and use ssh to bring the file back to the windows box for importing.

3. You can setup ftpd on the Unix box and setup a batch file or DTS to ftp the file from the unix box to the windows box for import.

4. You can install FTP on the windows box via IIS, ServU, etc and write a shell script on the unix box which FTPs the file from the unix box to the windows box.

I would suggest numbers 1 or 3.

Denny

--Anything is possible. All it takes is a little research. (Me)