Process each file in a folder
I have a folder of sql scripts that need to be executed in a specific order. The order is based on a number that is at the beginning of the file name. For example:
100_Sql1.sql
200_Sql2.sql
4000_Sql3.sql
10000_Sql4.sql
Does VBP have a built in mechanism for something like this or do I need to write a script for this?
Thanks!
|