> Hi Allan
> Thanks for replying. I've read that article before..
> The job is owned by the adminstrator id of the SQL server. This is the
> id
> that is used to log into the server as well as used by the SQL
> server's
> setting. I've checked that this user has the SQL server roles of
> System
> Administrator, Security, Server and Process.
> The jobs runs with no error message, saying someething like Job was
> successfully run yet the files are not copied over from remote server
> to this SQL server. The thing is using Windows Scheduled Task to
> called the batch file, it worked !
>
> I really need to know why SQL Scheduled of the DTS package calling the
> batch file doesn't work..
>
> "Allan Mitchell" wrote:
>
>> Hello Delf,
>>
>> Who owns the job?
>>
>> http://support.microsoft.com/?kbid=269074
>>
>> Allan
>>
>>> I have a batch file(.bat) that copies some files from a remote
>>> server to my SQL server.
>>>
>>> When I scheduled the DTS pakacge that calls this batch file, it runs
>>> succsesfully without errors. But the files are not copied over at
>>> all.
>>>
>>> So when I tested with the Windows Scheduled Task and Manullay
>>> execute the DTs package, both mehtods work ok with the files copied
>>> over to my SQL server.
>>>
>>> I just don't understand. My SLQ server and SQL server agent are
>>> using the Windows domain Id that has both local administrative
>>> rights and rights to the remote server.
>>>
>>> My startup service account is using This account specifying the
>>> window
>>> domain id that was used to log on to my SQL server
>>> Really appreciate if someone can advise me

"Allan Mitchell" wrote:

> Hello Delf,
>
> Is that a local administrator? Is there Network access involved in your
> package?
>
>
>
>
> Allan Mitchell
> www.SQLDTS.com
> www.SQLIS.com
> www.Konesans.com
>
> > Hi Allan
> > Thanks for replying. I've read that article before..
> > The job is owned by the adminstrator id of the SQL server. This is the
> > id
> > that is used to log into the server as well as used by the SQL
> > server's
> > setting. I've checked that this user has the SQL server roles of
> > System
> > Administrator, Security, Server and Process.
> > The jobs runs with no error message, saying someething like Job was
> > successfully run yet the files are not copied over from remote server
> > to this SQL server. The thing is using Windows Scheduled Task to
> > called the batch file, it worked !
> >
> > I really need to know why SQL Scheduled of the DTS package calling the
> > batch file doesn't work..
> >
> > "Allan Mitchell" wrote:
> >
> >> Hello Delf,
> >>
> >> Who owns the job?
> >>
> >> http://support.microsoft.com/?kbid=269074
> >>
> >> Allan
> >>
> >>> I have a batch file(.bat) that copies some files from a remote
> >>> server to my SQL server.
> >>>
> >>> When I scheduled the DTS pakacge that calls this batch file, it runs
> >>> succsesfully without errors. But the files are not copied over at
> >>> all.
> >>>
> >>> So when I tested with the Windows Scheduled Task and Manullay
> >>> execute the DTs package, both mehtods work ok with the files copied
> >>> over to my SQL server.
> >>>
> >>> I just don't understand. My SLQ server and SQL server agent are
> >>> using the Windows domain Id that has both local administrative
> >>> rights and rights to the remote server.
> >>>
> >>> My startup service account is using This account specifying the
> >>> window
> >>> domain id that was used to log on to my SQL server
> >>> Really appreciate if someone can advise me
>
>