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.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…