There is one more approach I have tried

Keep all the .sql files in one .sql file with their path as given below:

ON Error EXIT /*if you want to exit...