>>>>Did you already check sqlcmd parameters and samples in BOL?
>>>
>>>No, because this is really a windows command thing rather than a SQL Server thing, I think
>>
>>sqlcmd allows to output information into a text file. Go ahead and read BOL.
>
>OK, thanks. Any idea on checking the result of the copy command?

http://www.robvanderwoude.com/battech_redirection.php

Also, perhaps you want to use PowerShell script? It has more power than DOS batch file.