Hi..I have a FTP Location where every hour a new text file(comma separated values) is uploaded from an external source. I need to create a DTS Package which will check the FTP Location everyhour and if a new file is found it should retrieve the same and then dump the contents in a table of Oracle which resides on another server.
Urgent help pls.
Thanks