Append error in text file

I am running a script in batch ... with isqlw and oSql...

I want to loog all error in the process but a each command the file was reseted... who can I append the error in a text file??:confused:

Command exemples:
isqlw.exe -S %SERVER_NAME% -E -d master -o log_install.log - i install.sql
echo ...
isqlw.exe -S %SERVER_NAME% -E -d %DATABASE_NAME% -o log_install.log -i create_table.sql

At the end only error in create_table.sql was there!!

Who can I do??:confused:

thanksHowdy

Try coding the job as a job, not iSQL. Then you CAN append output to a file in the Advanced section of the job step.

Cheers

SG