Is there a tool that can run a set of sql scripts?

we work on 2 different environments.
one is the production environment where we develop and improve our system, and sometimes we have to do some changes in the data base involves both DDL and DML sql statements, and we usually write them in sql scripts so we can execute the changes to the operational environment.

I'm looking for an open source tool that helps you run a set of sql scripts which can be found in a specific given folder, and put the execution logs and errors into a file.

Thanks,
torti

This should be easily done using a bash script. Are u working under linux?

BR
DV