 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008output scheduled query to csv ?
using DTS to output scheduled query to csv ? Hi, I need to run a bunch of queries out with office hours when the system is quiet. Im using SQL agent to scheudule a query but i cannot seem to output the results c:\output.csv Easy when running a non-schedule query. Thanks for any help Scott > using DTS to output scheduled query to csv ? > [quoted text clipped - 8 lines] > Thanks for any help > Scott When a "job" is scheduled it runs under the security context of the windows account that runs the SQL Agent service. Does this account have the necessary NTFS permissions to write/modify to c:\output.csv? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.