I am getting new text file every month in CD format.
Now by DS which is installed in UNIX I want to run the job whose input file will be this file from CD. So I need to FTP text file from my client machine CD drive to UNIX. For this I want to write the script and use this script as before job subroutine in ETL job.
Welcome Aboard
It will be a standard ftp script. Search for more details. I believe there is a script in one of the posts that does the same.
What is CD format anyways?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
I have never done anything like this before but I am assuming that a CD drive will be treated like just another drive. The ftp will be run from the unix box, so the id should have access to your windows platform. Rest is straight forward, fire the script, get the file, process it.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.