SQL Server Performance Forum – Threads Archive
How to delete a DTS package passwordI 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,
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
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.