How can I reset/remove password security from the DTS
Pacakge. I have SA rights on the database/server.

You have to have the password so you can open the package
and then you do a Save As and save it with a different
package name and new password.
Without the existing password, you can't change or remove
the password.

-Sue

On Fri, 8 Aug 2003 10:00:28 -0700, "Avi"
<avi_bansal (AT) yahoo (DOT) com> wrote:

Thanks Sue,

So there isn't anyway (even for DBO/Server Admin.) to
open that DTS Package. Actually I have forgot the
password.

Avi

In article <01a201c35de0$78cfaf00$a401280a (AT) phx (DOT) gbl>, Avi
<Sue_H (AT) nomail (DOT) please> writes

Whilst you may be sysadmin in SQL or Windows Administrator neither of
these count for anything. A password DTS package is just an encrypted
COM structured storage stream. The encryption key is based on the
password originally supplied. There are no backdoor passwords or
overrides because of your admin status since there is no link there
between the encryption used and the existing security models.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com