How to delete a DTS package password | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to delete a DTS package password

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
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.
]]>