Post reply

DTS

  • July 23, 2004 at 12:58 pm

    #86168

    Does anyone know how to open a DTS package that  has a password in it - (if you don't have the password anymore?).  For SQL Server 7.0

  • July 26, 2004 at 5:22 am

    #516054

    Sorry, you're SOL.


    Pat Mong

  • July 26, 2004 at 7:49 am

    #516081

    Yes, if he you have access to the master table there is a dts_ table that contains the password in plain text.  Great security!

  • July 26, 2004 at 9:17 am

    #516113

    Which master table is it?  I don't see one directly related to dts.

  • July 26, 2004 at 10:14 am

    #516120

    Do you know the exact table?  I'm having the same problem.  I can't find any tables in model or msdb that would contain this information.  Thanks.

    out,

    swaders

  • July 26, 2004 at 10:30 pm

    #516210

    Don't know which version of SQL you're seeing this in.

    DTS Packages are stored as a Binary object in the sysdtspackages table which resides in msdb.

    I don't know any method for recovering a lost password from the DTS package.

    --------------------
    Colt 45 - the original point and click interface

  • July 27, 2004 at 6:30 am

    #516270

    I'm going to go out on a limb here and guess you didn't help him too much Phil. 

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

Viewing 7 posts - 1 through 6 (of 6 total)

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