all groups > sql server dts > april 2004 >
You're in the

sql server dts

group:

Lost DTS password



Lost DTS password John
4/21/2004 10:48:55 AM
sql server dts: We have a dts job that has a password assigned, but not
remembered. Is there anything that can be done to get into
the package and reset password?

Re: Lost DTS password Allan Mitchell
4/21/2004 7:02:56 PM
Password for the package?

If you have lost this then you have no way of retrieving it by other means.
You may want to give the boys and Girls at PSS a call and see if they can
help

--
--

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


[quoted text, click to view]

Re: Lost DTS password Darren Green
4/21/2004 7:34:23 PM
In message <256f01c427c8$ea7eaf90$a301280a@phx.gbl>, John
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

If you have a scheduled job with the encrypted DTSRUN command line
string, which should include the password, then that can now be
decrypted. If not nothing doing I'm afraid.

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

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