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
Scott

"Scott" <scott_lotus@yahoo.co.uk> wrote in message
news:ujtQYUC6IHA.1196@TK2MSFTNGP05.phx.gbl...
> 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
> 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?