Re: Executing a DTS package with "AT" command

I have an ActiveX script within a DTS package that executes every 30 minutes
checking for any text files that need to be imported. These text files,
however, are imported using any one of a number of DTS packages. So, in my
script I find the package that needs to be executed for the particular text
file and build the DTSRUN command line along with the AT command to schedule
it. WshShell is used to run that command line. This way, the DTS package
with the ActiveX script does not have to wait until the import is finished
before finishing and running again in another 30 minutes. The SYSTEM account
definitely won't work. I want the package to run under the same domain
account as the SQL agent but scheduling with the AT command appears not to
allow the package to run under the SQL agent.

"Darren Green" wrote:

> In message <09D29E60-1FDD-42FE-83CC-0C98C8E10B0A@xxxxxxxxxxxxx>, Bill
> <Bill@xxxxxxxxxxxxxxxxxxxxxxxxx> writes
> >I'm using SQL Server 2000 SP4 and am trying to execute a DTS package using
> >the DTSRUN utility using the "AT" scheduling command in Windows Server 2003.
> >Unfortunately, the job fails and the reason is because the package is being
> >executed by user SYSTEM. I can tell this by the log file. I've read
> >Microsoft article 269074, but this does not quite apply because I actually
> >*can* get the package to run both interactively and as a scheduled job
> >*within* SQL. The problem appears to be with scheduling this in the O.S.
> >This used to work under Windows Server 2000. Any ideas?
>
> You may be able to run the package interactively, and under the SQL
> Agent service account, but are either of these SYSTEM? If not then you
> have not tested it yet, as the account is very important. Why not use
> the Windows Scheduler service ( is this base don AT, I thought it was),
> but the key point is the GUI allows you to specify an account to use.
>
> To be honest why use AT when SQL Agent does a better job anyway.
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>
>
.

Relevant Pages

  • RE: dts package error
    ... database on a different server with information on my SQL once a week. ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Help Newbie - SSIS run in SQL server agent job
    ... 90% of all "SSIS using SQL Agent" issues are caused by the SQL Agent ... service account not having the correct permissions. ... still get this problem check the Package Protection Level.. ...
    (microsoft.public.sqlserver.dts)
  • RE: dts package error
    ... "Donna Lambert" wrote: ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Privilege in scheduling packages through sql agent jobs
    ... > How to Run a DTS Package as a Scheduled Job ... >>A programmer can schedule jobs through sql agent and the job step that is ... >>programmer runs the package interactively, ... >>attempts to schedule a package as sql agent job, ...
    (microsoft.public.sqlserver.security)
  • RE: 64bit SSIS package calling 32bit SSIS package
    ... Now tried 32bit end to end from sql agent (so running the control job in ... packages using 32bit jet theres also a config value to execute these with the ... Execute the control package from the command line on the server as my proxy ... I cannot run the same package from a sql agent job as whe nthe control ...
    (microsoft.public.sqlserver.dts)
Loading