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

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_ (AT) _shu (DOT) ac.uk_> wrote

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 (AT) no-spam (DOT) sqldts.com> wrote

I only ever use a name when calling the package

In your case you could programmatically

Open Old Package
Save As New Name (1)
Save As Archiveing Name
Delete Old Package
Open New Name (1)
Save As Old Name

This sounds long winded but it can be automated using some VBScript.



--

----------------------------

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_ (AT) _shu (DOT) ac.uk_> wrote