I am new at SQL
I would like to create an SQL scipt
that would take an text file and rename the text file to the day month and year
eg. rename the text file invoices.txt to 10092007.txt
and copy it to a FTP site
How do I do this ?
Please help me I need to set this up to run every day