Trouble with SQL output to a file

  • Having trouble with directing SQL output sent to a file from command line as well as batch file in SQL 2000.

    Code:

    osql -S -o <outputfile.csv

    In the output file I dont see the statements executed.

    Where am I missing?

    Thanks for your time!

  • Do not post a new topic, you could just put a new reply as an updated script you need to be helped out with..my version is same again

    OSQL.EXE /n /S "servername" /U login /P "pswd" /d DB Name /i "Input file pathl" /o "output file path"

    Hope this helps

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • a little bit of de ja vue with this post me thinks 🙂

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply