hi,

Every one hour, i need to update my sql server tables. I will be getting
the informations from a third party vendor who is in different location.
They are sending the information in text file. What i need to do is, write
a code to automate the process, so that for every one hour Sql server has
to connect to the ftp server and has to download the text file and get updated
in my tables. Please help me , it's very urgent.

Regs
Siva