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

Hello Delf,


Who owns the job?


http://support.microsoft.com/?kbid=269074


Allan

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,

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,

Thank you for your reply.
That user id is a domain administrator. Yes there is network access in
package.
Previously my bat script use something like :G:\....." to reference the
remote server (this works when I run manually ) . I read M/S article about
using UNC reference so i change the script (again its can only run manually
but not scheduling). The purpose of script is to copy the files on remote
server to the SQL server.

After scheduling, there is no error message but the files are not copied
over.

What else can I try ?

"Allan Mitchell" wrote: