(ralle) wrote:

>Hallo Sue ,
>thanks for your reply.
>The textfile is located on the same server.
>Have you got another idea
>Ralf
>
>Sue Hoegemeier <Sue_H@nomail.please> wrote in message news:<6hq7701pfqhmmnrfp8i7g561mkqmelju9e@4ax.com>...
>> Are you copying the data to a text file on another server?
>> In that case, you can't have SQL Agent running under local
>> system as that account does not have network access - you
>> would need to use a domain account.
>> You can find troubleshooting steps for problems when a
>> package doesn't run when scheduled in the following:
>> INF: How to Run a DTS Package as a Scheduled Job
>> http://support.microsoft.com/?id=269074
>>
>> -Sue
>>
>> On 7 Apr 2004 04:31:28 -0700, kralemann.r@bex.battenfeld.com
>> (ralle) wrote:
>>
>> >Hallo to all,
>> >I hope the SQL and DTS experts can help me.
>> >I have problems with sheduling a small script copy data from Sql2000
>> >to a flat txt-file.
>> >When executing it in SEM on a different PC it works fine
>> >when sheduling it on the sql server it fails with error 208.
>> >I read a lot about this in the news group and thought the
>> >SQLSERVERAGENT has missing rights.
>> >I granted SA Permission to the services MSSQLSERVER and SQLSERVERAGENT
>> >( with local system account = has admin rights )
>> >I logged in on the server with also SA rights.
>> >I got everytime the same error.
>> >What should I do to allow SQLSERVERAGENT to execute the job.
>> >Many thanks in advance
>> >
>> >Ralf