Re: Batch File in DTS

Hello,

I assume that you are running SQL Server 2000.

If you tested this on your desktop, then the DTS package was running with
your security credentials.

But, when you schedule the job the SQL Agent you will be running in the
server context with the credentials of either the server account (if the job
is run as a system administrator) or else of the SQL Agent proxy account.
If the necessary account does not have rights to the folders, then the job
will fail.

SQL Server 2005 supports many proxy accounts which can be granted the
appropriate rights. (Even your personal Windows login can be turned into a
SQL Agent proxy. (But I don't recomment that.))

RLF

"thanksforhelp" <thanksforhelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DB9FB32B-BB19-428F-B62A-AF33165E9726@xxxxxxxxxxxxxxxx
Hi,

I have a batch file, copies a xls file for one dir to another and delete
source file. This works in DTS package, but when I schedule the package,
it
fails.

Any help in ver much appreciated.


.

Relevant Pages

  • RE: xp_cmdshell, Access Denied, Further Investigation Reveals
    ... As i tried to explain the Agent proxy account has Admin rights, ... this share and security tab show the admin group in with this user ... This is not just a problem with SQL if you read below i used ... > member of the sysadmin group, xp_cmdshell will impersonate the SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: dts package and t log
    ... But isn't it possible to start a dts package and as the first step use some ... kind af statement to tell sql not to fill up ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > worth of t-log space. ...
    (microsoft.public.sqlserver.dts)
  • Re: Job Scheduler fails and Managing Tempdb
    ... You can turn logging on on both the job and the DTS Package to get some more ... As I said in my previous post, shrinking tempdb is not very useful. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Source table filtering in DTS by target table values.
    ... I am new to SQL Server and to DTs. ... for the client master. ... file (created in the DTS package) and add them batch by batch ...
    (microsoft.public.sqlserver.dts)
  • Re: Creating a DTS ActiveX Task
    ... (this is the service that runs jobs in SQL Server) ... the 'logon as' tab, you'll see what account this service runs as, this is ... from the network from your DTS package you'll be fine, ... > I'm not very familiar with SQL Server, I only know some VB and TSQL. ...
    (microsoft.public.sqlserver.programming)
Loading