We are using FTP to transfer a number of files from another machine(the type and details are not important) to SQL Server.
At the end of the nightly process I will receive a Text file called READY.txt, which will let me know that the process has completed from that server.
I would like to create a sp that checks every five minutes for that file. I understand the job schedule portion.
THE QUESTION: How do I create either a DTS package or a sp to search for this file to start my evening's / morning's processes? I am looking for something that states:
If C:/FTP/READY.txt exists
Then go to the next step
Else keep waiting until my time is up.