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 |
|
errrick
Starting Member
4 Posts |
 Posted - 2009-12-30 : 16:22:49
|
| Hi,Is there a way I can setup a scheduled task that will run a specific SQL query (basically a SELECT statement) and automatically export the results to a file (that could be a CSV or whatever human readable/parser friendly format)Note: SQL Server 6.5 is not reachable via remote access. All must be done in an NT4 system by connecting locally.Thanks!Eric |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-31 : 04:49:26
|
| you could also just schedule a regular NT4 job with the AT command running the batch file but the method Tara illustrates is probably easier to keep track of as it's more logically tied to sqlserver.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
errrick
Starting Member
4 Posts |
Posted - 2010-01-04 : 08:10:40
|
| Thanks Tara / Charlie, will try that. I thought that bcp.exe didn't even exist in 6.5 :p |
|
|
|
errrick
Starting Member
4 Posts |
Posted - 2010-01-04 : 10:24:14
|
| I just found that BCP in SQL 6.5 does not allow to run custom queries, it can only export tables (it doesn't even let me select which columns I want!)Is there any other approach? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
errrick
Starting Member
4 Posts |
Posted - 2010-01-04 : 13:47:54
|
| Tara, bcp.exe in SQL 6.5 does not have the queryout option. However I figured out the View solution already.. it seems to do what I want, thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
schedule a SQL query, and export to a file (csv)?
Tara Kizer