FTP text file from CD

ganesh123 · Post by **ganesh123** » Tue Feb 20, 2007 3:26 pm

Hi Gurus,

I want to perform following task :

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.

Any ideas gurus, please share?

Am I going correct ?

DSguru2B · Post by **DSguru2B** » Tue Feb 20, 2007 3:29 pm

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?

ganesh123 · Post by **ganesh123** » Tue Feb 20, 2007 3:31 pm

I mean I am getting new files in Compact Disk.(CD)

ganesh123 · Post by **ganesh123** » Tue Feb 20, 2007 3:32 pm

I want to do every thing automatic, just insert CD in drive and run the job from DS. Is it possible ?

DSguru2B · Post by **DSguru2B** » Tue Feb 20, 2007 3:40 pm

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.

kumar_s · Post by **kumar_s** » Tue Feb 20, 2007 5:05 pm

Once the CD is mounted in Unix, you should be able to access it as usual.

ganesh123 · Post by **ganesh123** » Tue Feb 20, 2007 5:55 pm

Hey kumar I donot have to mount the CD on unix, I have to mount it on my PC (client)which is windows and then start the job to run.

ganesh123 · Post by **ganesh123** » Tue Feb 20, 2007 5:59 pm

So I guess I have to design 2 jobs in sequence

1) FTP the txt file from CD to Unix box
2) Use this file as source

Seq_txt_File------------TX--------------Database

Is this correct ?

kumar_s · Post by **kumar_s** » Tue Feb 20, 2007 6:12 pm

Correct.

ganesh123 · Post by **ganesh123** » Tue Feb 20, 2007 6:19 pm

Thank you DSGuru and Kumar. I really appreciate your time.