Re: Changing DTS Package Password

• Previous message: Andreas Terzis: "Re: Pass variables from parent DTS to child DTS package..."
• In reply to: Allan Mitchell: "Re: Changing DTS Package Password"
• Next in thread: Allan Mitchell: "Re: Changing DTS Package Password"
• Reply: Allan Mitchell: "Re: Changing DTS Package Password"
• Messages sorted by: [ date ] [ thread ]

Date: Thu, 13 May 2004 09:37:41 +0100

Thanks for this Allan, though this is pretty poor from Microsoft. The
package is part of a scheduled job, so saving it with a new name gives it a
new ID(?), so the scheduled job has to be edited as well (?)

Thanks again,

Ken

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:Oma2tZDOEHA.3816@TK2MSFTNGP12.phx.gbl...
> You need to "Save As"
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Ken Cooper" <_k.a.cooper_@_shu.ac.uk_> wrote in message
> news:egkzmXDOEHA.3380@TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > I have been asked to move a DTS package between servers and to remove
the
> > package password. I know the password and can edit the package on the
new
> > server, but can't see an option anywhere to change or remove the
password.
> > DOH! I confessed my inexperience with DTS and asked a colleague
expecting
> to
> > be shown up for missing the obvious, but no, he couldn't see how to do
> this
> > either. So I feel slightly better, but still no further forward with the
> > task. Can anyone point us in the right direction?
> >
> > Option doesn't seem to be available with a new password protected
package,
> > so I don't think this has anything to do with moving the package between
> > servers.
> >
> > Many Thanks,
> >
> > Ken
> >
> >
>
>

• Previous message: Andreas Terzis: "Re: Pass variables from parent DTS to child DTS package..."
• In reply to: Allan Mitchell: "Re: Changing DTS Package Password"
• Next in thread: Allan Mitchell: "Re: Changing DTS Package Password"
• Reply: Allan Mitchell: "Re: Changing DTS Package Password"
• Messages sorted by: [ date ] [ thread ]