IF NOT %1!==/go! %0 /go %* 1>%~n0.log 2>&1
ECHO %1 %2 %3 %4 %5
If the above batch file was named "logging-sample.bat", "logging-sample.log" would be created. Invoking the above batch with arguments from the command line such as:
logging.bat A B C D E
would preserve the passed arguments, and store "A B C D E" in logging-sample.log. Just replace the ECHO command with your copy/sqlcmd scripts. If preserving arguments isn't an issue, you can omit %* and SHIFT. I can't take credit; I snagged it (or a variation) off the 'net years ago!
When your only tool is a hammer, every problem looks like a nail.