Using vbld_AddDelimValue() and then calling the Run Sql action could be a good idea. The only problem could be the performance
(
Another way could be to create directly by script the project (with the VBPro object model) which will lauch step by step each stored procedure and then to launch it after. But each step has to connect to the database, so you will lose always the same amount of time.
But every day, I have to install 3500 stored procedures and this way takes me 15 minutes if I use this method.
To reduce that time at 5 minutes, we had to create a visual basic code (attached with this message). The idea is to use ADO directly keeping the connexion to the database always opened.
I haven't fund the time to translate it in VBScript but I'm sure you
could easily. But I will do it... one day ;o)
"Le petit frenchy"
NB: Sorry for my english ;o)