Toad World® Forums

How to have TDP check if a file exists

#1

I'm wondering if there is a way for TDP automation to check to see if an excel file has been dropped off in folder. If the automation finds the file I want it to continue the rest of the automation (using an If..condition system activity), otherwise if the file is not there I want the automation to exit.

I don't see anything in the database activities, file activities, or system activities that would do this. Any advice would be appreciated, thanks.

#2

You could use a run activity and run a bat file that returns a number if file exists. This return code would go into a variable and you can apply your If statement based on the Run Activity exit code.