Recover lost DTS packages

Question

Recover lost DTS packages

Helen-84411

Hall of Fame

Points: 3320
More actions
August 10, 2005 at 1:19 am

#67830

Hi gurus
Is it is possible to recover/initialize a lost DTS package owner password in SQL Server 2000. The createor of the package sealed it with a password and then left the company.
what about sysdtspackage in msdb?
Do you know a method to do this? Maybe a 3rd party tool?
Thanks

Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

As far as I know, there still is no way to do this. The password is encrypted within the package id in sysdtspackages. It's not stored in plain text anywhere.

Greg

Ghanta Bro Ten Centuries Points: 1079 More actions · Answer 2

there is one way... look for his number and call him...

sorry

Helen-84411 Hall of Fame Points: 3320 More actions · Answer 3

Hi Greg,
Thanks for your comments. Can you please tell me if this will work
If I save the DTS package as a structured storage file, and then log in as the user who you
want to own the package, open the package and save it (with a different name).

Thanks

Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me

Greg Charles SSC-Forever Points: 45403 More actions · Answer 4

Hi Helen,

That will work. You'll end up with two packages with different names and different owners. This isn't a work around for your original problem, however, because you can't save the package unless you can open it in DTS Designer and you can't open it unless you know the owner password.

Greg