Re: Scheduled DTS Package

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 18:52:09 +0000

What does your cmdline look like that executes the package? DTSRUN
~/Z.............

In the DTSRUN string when you create it do you specify a SQL Server
login with which you connect to the package server?

Does this password change?

"jmeyers" <jmeyers@discussions.microsoft.com> wrote in message
news:jmeyers@discussions.microsoft.com:
> I have a DTS package that is schedule to run daily. The DTS package was
>
> created and made the connection to the SQLServer using Windows
> authentication. When the package runs, it runs under the user/password of
>
> the SQLAgent. About every 3 months, we go through a security cycle in
> which
> the user running the SQLAgen has a password change. Everytime that
> password
> changes, even though the scheduled DTS is using Windows authentication,
> the
> job fails until I delete the schedule, and recreate it. If I execute the
> DTS
> without the schedule, it runs fine. However, until I reschedule it, it
> won't
> pick up the password change. Why? And, most importantly, is there a way
>
> around this or should I be setting this up differently to avoid this
> problem?
>
> Thanks in advance,
> Joan

Relevant Pages

  • SSIS Scheduling Failure - AcquireConnection Error
    ... package into SSIS services in Management Studio and ran the job manually. ... I got the dreaded 'AcquireConnection' error when I tried to schedule ... while logged onto the SQL Server 2005 database server itself. ... the 'SQL Agent Service Account'. ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduled DTS Package
    ... >> I have a DTS package that is schedule to run daily. ... >> the user running the SQLAgen has a password change. ... >> job fails until I delete the schedule, ...
    (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: Odds n ends, part II
    ... up mostly just being about the schedule. ... Genuine SB (FSB for now) is back, which everyone pretty much knew had to be part of any package that the factories would underwrite. ... The second has only one literbike class, which is what the Japanese factories favor, but SB would be dumbed down, the mentioned stock components required being forks and swing arms, and no alternate gear ratios. ... He makes it sound like electronics may have to be stock as well, which creates issues when bikes like the 1098R are allowed into the class (that bike including a race kit as part of the stock package). ...
    (rec.motorcycles.racing)
  • Re: DTS job error
    ... the DTS schedule package functionality - you right click on ... the package on select Schedule Package. ... DTSRUN /~Zxxxxxxxxxxxx. ...
    (microsoft.public.sqlserver.server)