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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2009-07-30 : 01:19:29
|
| Gurus,I have a SP and now i want that output of that SP should be stored in CSV file.Please HelpRegardsNitin |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2009-07-30 : 02:32:48
|
| i want to schedule it thru bacth file also, i dont want to make a job(sql agent job)How do i go about itRegards |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-07-30 : 02:37:19
|
quote:
Originally posted by nitin1353
i want to schedule it thru bacth file also, i dont want to make a job(sql agent job)How do i go about itRegards
BCP is a command line feature u can use in a batch file and schedule the batch file using Scheduled task in Control pannelSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2009-07-30 : 03:51:54
|
| How do we exec a sp from bcp?Regards |
|
|
|
asgast
Posting Yak Master
149 Posts |
Posted - 2009-07-30 : 04:04:27
|
| you don't exec a sp from bcpcreate procedure that uses bcp to write into filesuse sqlcmd to run sql scripts from a batch filehttp://msdn.microsoft.com/en-us/library/ms162773.aspx |
|
|
|
|
|
|
Output to CSV file