SQL Server Performance Forum – Threads Archive
Unlock a DTS package
hi,I need to unlock a DTS package which the developer has locked with a password and has quit the job. I checked sysdtspackages table but couldn’t find the password. Please somebody help me. Thanks
Raj
Can somebody please help me with this?
Raj
Check this out:http://jimmers.russia.webmatrixhosting.net/dtspackage2.aspx May the Almighty God bless us all!
www.empoweredinformation.com
I think you are looking for owner password, if yes then
unfortunately there is no way i guess to get that forgot password back
Try accessing with SA password, it may help. If not follow as suggested above. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks a lot for the above link,<br />there is a batch file which has these two commands<br /><br />cl /nologo /c DTSConnPass.cpp<br />link /nologo /defaultlib<img src=’/community/emoticons/emotion-3.gif’ alt=’

see if that file came with the .exe file. else google for C Compiler download
see this:
http://www.digitalmars.com/download/freecompiler.html May the Almighty God bless us all!
www.empoweredinformation.com
]]>