Hello,
Apologies for the inconvenience. What we suggest is, as a part of task, create a temporary folder, copy the file with modified date in last 30 days, loop for that temp folder and update sql and at the end delete that temporary folder. That way is reliable and faster. Below is the text format of task.
Create Folder "C:\Temp"
Copy Files "C:\SourceFolder\*.*" to "C:\Temp\" if file is modified in last 30 days
Start Loop " Each File in C:\Temp"
SQL SELECT using $FileName$
Loop through SQL
IF $Database Column(1)$ includes "xxxxx" then
SQL Insert
SQL Update
Email
End Loop
End Loop
Delete Folder "C:\Temp"
Hope that helps.
|