SQL Server Performance

Unlock a DTS package

Discussion in 'SQL Server DTS-Related Questions' started by rajeshraghavan, May 16, 2006.

  1. rajeshraghavan New Member

    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
  2. rajeshraghavan New Member

    Can somebody please help me with this?
    Raj
  3. cmdr_skywalker New Member

  4. ranjitjain New Member

    I think you are looking for owner password, if yes then
    unfortunately there is no way i guess to get that forgot password back
  5. satya Moderator

    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.
  6. rajeshraghavan New Member

    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=':eek:' />le32.lib oleaut32.lib <br /><br /><b>cl</b> I think is the C-compiler what about <b>link </b> I tried googling but couldn't find anything related.<br /> Also where to place the batch file for execution, there is not even a readme file,<br /><br />However thanks a lot it just gives me a ray of hope that the user password can be unlocked.<br />
  7. cmdr_skywalker New Member

Share This Page