Try this:

@echo off

if #%1# == ## goto noparm

echo running %1

echo ####################### running %1 #######################>>log.txt

osql -U log.txt

goto :done

:noparm

echo ####################### Start Process #######################>log.txt

for %%X in (*.sql) do (call %0 %%X)

echo ####################### End Process #######################>>log.txt

start notepad log.txt

:done

Put all your script files into the same directory. How do you control the order they run in? Simple. By default NTFS directory results appear in alphabetic order 😎

I wrote a Dot Net program that dumps tables as insert statements. I run that to export data and run this to do the imports. This way i avoid all the hassle of column order issues with BCP.