<div>
something like this in an sp scheduled every 5 mins.<br />
<br />
create table #a (s varchar(1000))<br />
insert #a<br />
xp_cmdshell 'dir /B C:/FTP/READY.txt'<br />
<br />
if exists (select * from #a where s like ...)<br />
<br />
look at the result you get in #a for the file - you might want to check the file date too.<br />

</div>


something like this in an sp scheduled every 5 mins.

create table #a (s varchar(1000))
insert #a
xp_cmdshell 'dir /B C:/FTP/READY.txt'

if exists (select * from #a where s like ...)

look at the result you get in #a for the file - you might want to check the file date too.


<div>
Thanks ... Sorry I took so long to respond, but I needed to make time to test. &nbsp; 
</div>


Thanks ... Sorry I took so long to respond, but I needed to make time to test.  

<div>
<div class="content wysiwyg-content">
We are using FTP to transfer a number of files from another machine(the type and details are not important) to SQL Server. &nbsp;<br />
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.<br />
<br />
I would like to create a sp that checks every five minutes for that file. &nbsp;I understand the job schedule portion. &nbsp;<br />
<br />
THE QUESTION: &nbsp;How do I create either a DTS package or a sp to search for this file to start my evening's / morning's processes? &nbsp;I am looking for something that states: &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If C:/FTP/READY.txt exists<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Then go to the next step <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Else keep waiting until my time is up. <br />
<br />
Thanks. <br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />

</div>
</div>


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. 

Thanks. 

          


SP /Trigger -  File Search to begin jobs.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.