Hi C,
You can have the SQL statements in a collection, then loop the collection and execute each SQL statement with the SQL VBO as you loop. The collection could be fed directly from the .sql file by reading it and adding each statement to a new row in the collection.
An other way is to write a new VBO for the application you would manually run the SQLs in. Make actions to launch and attach the application, load the .sql file and execute it as if you were running it yourself. Then write a process calling the new VBO steps.
That said, 1000 SQLs is quite a lot, and depending on the performance of the SQL statements against the databases, it might take a while to do them all.
------------------------------
Happy coding!
---------------
Paul
Sweden
------------------------------
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)
