Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mpolaiah
Starting Member
24 Posts |
 Posted - 2009-08-06 : 01:48:45
|
| Hello,I have several sql scripts to be executed on a set schedule, with the output directed to a text file. If the schedule triggers this process daily, is it possible to append each days output to the same output file? I've researched the osql switches and various online sources...nothing really covers this.This is done (relatively) easily with .vbs, but so far it looks tougher with TSQL.Many thanks to all who respond! |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-08-06 : 06:36:55
|
quote:
Originally posted by mpolaiah
Hello,I have several sql scripts to be executed on a set schedule, with the output directed to a text file. If the schedule triggers this process daily, is it possible to append each days output to the same output file? I've researched the osql switches and various online sources...nothing really covers this.This is done (relatively) easily with .vbs, but so far it looks tougher with TSQL.Many thanks to all who respond!
use >> operator with osql...this is a dos operator to append text to file... |
 |
|
|
|
|
|
how to text file append?