[helena]

Is there anyway to call a VBP step from within a Script block?

The problem that I'm trying to solve is that I have a folder filled with .sql files. Each file name starts with a number, such as 100, 200, 1100, and the sql files need to be run in numeric order (rather than alphabetical).

I created a jscript step that would go through all the files in the directory and stick the paths into an array so that they're in the correct order.

After all the files are ordered correctly, I would like to run the all the sql files in the appropriate order. This is where I run into the problem. How do I run all these file in the correct order?

Ideally, I'd like to loop through all the items and call the Run Sql step with the information or run the %DOSCMD% with the correct command from within the script code. I haven't been able to figure out how to call any VBP steps from within the script, or how to pass the list of file paths out to another step to run all of them in order.

Any ideas?

Thanks!