Post reply

Recover lost DTS packages

  • 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

  • August 10, 2005 at 1:24 pm

    #581166

    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

    Greg

  • August 10, 2005 at 2:25 pm

    #581207

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

     

    sorry

  • August 11, 2005 at 12:02 am

    #581280

    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

  • August 11, 2005 at 11:56 am

    #581512

    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

    Greg

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

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