Re: Scheduled Package Results Contradictory

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • Re: DTS Package
    ... DTS is a client side software. ... I created a SQL Server DTS package when connecting to the SQL server on my ... We have a batch file created which was scheduled to run every Tue. ...
    (microsoft.public.sqlserver.server)
  • DTS Package
    ... I created a SQL Server DTS package when connecting to the SQL server on my ... We have a batch file created which was scheduled to run every Tue. ...
    (microsoft.public.sqlserver.odbc)
  • DTS Package
    ... I created a SQL Server DTS package when connecting to the SQL server on my ... We have a batch file created which was scheduled to run every Tue. ...
    (microsoft.public.sqlserver.server)
  • Re: replication to sql server by activeX
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... on another machine and the batch file is working fine. ...
    (microsoft.public.sqlserver.replication)
  • Re: Using SQLCMD to test Connection
    ... Assuming you really execute the batch file from the operating system command interpreter, then you should now have some other error compared to the one you posted earlier. ... Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. ... SQLCMD is not a SQL command, ...
    (microsoft.public.sqlserver.clients)