• BCP outputs data to a file, SQLCMD to a file or console, so you can redirect console to a file with > or >>:

    rem create output.txt

    sqlcmd commands > Output.txt

    rem append to output.txt

    sqlcmd commands >> Output.txt