In article <018901c38832$3a5f1cc0$a301280a (AT) phx (DOT) gbl>, Mark Wilson
<mark.wilson2 (AT) pfizer (DOT) com> writes
If you do not know what the Package password is then you are in trouble.
Just because you can connect to the SQL Server as a sysadmin has no
bearing on the DTS passwords and "security". The SQL Server and DTS are
two separate things entirely. You can connect to SQL Server from DTS and
you can store your DTS packages in a SQL Server, but being admin on the
SQL Server does not give you the ability to override the wonder or user
password of a package.

The package is basically encrypted, and it cannot be decrypted with a
key. Perhaps GCHQ or the NSA could break it, but that is a resource
beyond most people.

You write a brute force program to try passwords against a package. It
may take some time!

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

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

You can't. If you do not know the Owner password then you cannot alter the
package period.
I would open up a support incident with the boys and girls at PSS. They
*may* have the tools to do it for you.



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Mark Wilson" <mark.wilson2 (AT) pfizer (DOT) com> wrote