DSXchange

Hello,

I have a requirement to read files present on remote Windows shared drive and process it further. Once processing is complete the ETL code should be able to delete remote files. To read remote file on Windows shared drive I use FTP stage but I'm unable to figure out how to delete that file from DataStage or UNIX. If the remote server were to be UNIX then I would use rsh but not sure how to proceed since it's Windows server. Any help would be appreciated.

Thanks for your time

I believe you would use rsh for this as well.

On your windows server, install the Cygwin's OpenSSH server and client utilities. Then you should be able to delete the files on the Windows server.

Does not the FTP stage allow an "after" telnet command? You could use this to delete the file.

@chullet,
I believe rsh would work on remote Windows machine if MKS toolkit is installed and rsh is configured.

@lstsaur
Not sure if my Windows admin would let me install a Cygwin's server. I'll try Ray's advice first and if it doesn't work then I'll go with Cygwin approach.

@all
Thanks guys.

For the FTP stage, make sure you've got all of the permissions you'd need. Just because you can ftp somewhere doesn't automatically mean you can telnet there as well.

Thanks Craig. I'll keep that in mind :D

ray.wurlod wrote:Does not the FTP stage allow an "after" telnet command? You could use this to delete the file.

in cases where you don't know which files you will get (ex 3 files one day 6 files next day) what if new file emerges just after you have "gotten" your files.

Don't you risk getting 3 files, but in the "after" you will delete 4 files ???

ray.wurlod wrote:Does not the FTP stage allow an "after" telnet command? You could use this to delete the file.

in cases where you don't know which files you will get (ex 3 files one day 6 files next day) what if new file emerges just after you have "gotten" your files.

Don't you risk getting 3 files, but in the "after" you will delete 4 files ???