SQL Server Performance

How to delete a DTS package password

Discussion in 'SQL Server DTS-Related Questions' started by spalakollu, Nov 30, 2005.

  1. spalakollu New Member

    I have few DTS packages that was written by some person and left the company by making the DTS packages as password protect. I am not able to open/execute/schedule those packages. Please let me know how can I unlock those packages and make use of them.
    Thanks in Advance,
    Siva
  2. Luis Martin Moderator

    The DTS password could be: Windows Authentication or SQL Authentication.
    So, if Windows A. then you have to find out via Windows Administrator.
    If SQL Authentication, must be a SQL user login. So, if you are SA, you can change any login password.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page