October 21, 2008 at 1:37 pm
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!
October 21, 2008 at 1:55 pm
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."
October 21, 2008 at 1:59 pm
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