Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Canada
    Posts
    45

    Question Unanswered: 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??

    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??

    thanks
    Franky
    FBoucheros@hotmail.com

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •