Re: DTS job error
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/01/04
- Next message: Nigel Rivett: "RE: DTS job error"
- Previous message: DHatheway: "Re: Sp_helpdb fails, model db has null owner"
- In reply to: Mike: "DTS job error"
- Next in thread: Mike: "Re: DTS job error"
- Reply: Mike: "Re: DTS job error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 01 Apr 2004 08:00:21 -0700
I would guess that you may have scheduled the packages using
the DTS schedule package functionality - you right click on
the package on select Schedule Package. In this case, the
job will create an encrypted string for the dtsrun utility -
the command in the job step looks like:
DTSRUN /~Zxxxxxxxxxxxx.
The login and password that is encrypted in this string is
based upon what login and password was used in Enterprise
Manager to register the server. If you change the password
that was used when scheduling the package, the password
embedded in the encrypted string is no longer valid.
You can either change the dtsrun commands in the jobs, just
entering the dtsrun parameters yourself.
Or you can use the dtsrunui utility to generate a new
encrypted command. From the advanced button on the dtsrunui
utility, there is an option to generate a command line. It
will be based on whatever login you use when the dtsrunui
utility starts.
-Sue
On Thu, 1 Apr 2004 06:48:24 -0800, "Mike"
<anonymous@discussions.microsoft.com> wrote:
>Hi,
>
>I scheduled a DTS, with right click above it, for every 2
>hours. A job is automatically created to control the
>execution that a specified. I save the DTS within SQL
>Server with dba user. If i change DBA password, my job
>execution reports an error saying, login failed for user
>dba ..., i don't have this user within any step regarding
>the DTS, why this happens ? if i delete the job and
>recreate it using right click above the DTS, then the job
>start working fine. Any ideas ??
>
>Thanks a lot
>Mike
- Next message: Nigel Rivett: "RE: DTS job error"
- Previous message: DHatheway: "Re: Sp_helpdb fails, model db has null owner"
- In reply to: Mike: "DTS job error"
- Next in thread: Mike: "Re: DTS job error"
- Reply: Mike: "Re: DTS job error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
