topic RE: How to execute .sql file with 1000 queries using SQL VBO.. in Product Forum https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86657#M37479 ...and don't forget to let us know how it worked out for you!<BR /><BR />------------------------------<BR />Happy coding!<BR />---------------<BR />Paul<BR />Sweden<BR />------------------------------<BR /> Wed, 21 Dec 2022 10:01:00 GMT PvD_SE 2022-12-21T10:01:00Z How to execute .sql file with 1000 queries using SQL VBO.. https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86654#M37476 HI, <BR /><BR />How to execute .sql file with 1000 queries using SQL VBO..<BR /><BR />Any suggestions how to achieve this using SQL VBO<BR /><BR />------------------------------<BR />chakravarthy<BR />Asia/Kolkata<BR />------------------------------<BR /> Tue, 20 Dec 2022 08:03:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86654#M37476 chakravarthy 2022-12-20T08:03:00Z RE: How to execute .sql file with 1000 queries using SQL VBO.. https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86655#M37477 Hi C,<BR /><BR />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.<BR /><BR />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.<BR /><BR />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.<BR /><BR />------------------------------<BR />Happy coding!<BR />---------------<BR />Paul<BR />Sweden<BR />------------------------------<BR /> Tue, 20 Dec 2022 09:17:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86655#M37477 PvD_SE 2022-12-20T09:17:00Z RE: How to execute .sql file with 1000 queries using SQL VBO.. https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86656#M37478 HI Paul,<BR /><BR />Thank you for the suggestion, will try it.<BR /><BR /><BR />------------------------------<BR />chakravarthy<BR />Asia/Kolkata<BR />------------------------------<BR /> Wed, 21 Dec 2022 04:45:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86656#M37478 chakravarthy 2022-12-21T04:45:00Z RE: How to execute .sql file with 1000 queries using SQL VBO.. https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86657#M37479 ...and don't forget to let us know how it worked out for you!<BR /><BR />------------------------------<BR />Happy coding!<BR />---------------<BR />Paul<BR />Sweden<BR />------------------------------<BR /> Wed, 21 Dec 2022 10:01:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-execute-sql-file-with-1000-queries-using-SQL-VBO/m-p/86657#M37479 PvD_SE 2022-12-21T10:01:00Z