Post reply

How to remove password from all DTS Package

  • January 8, 2004 at 7:48 pm

    #107574

    Dear All,

    I have a lot of DTS Packages in my SQL Server 2000. All of them have password. Now, I need to remove the password.

    How can I remove all the password by using T-SQL? Any extended store proc???

     

    Regards,

    kokyan



    Regards,
    kokyan

  • January 9, 2004 at 11:09 am

    #489427

    T-SQL will not do the trick, the quickest way is to open up the packages and execute some VB code from an ActiveX task, assuming the passwords you are talking about are in the conncetion objects.

    If you are talking about package execution passwords, that could be done in a similar manner.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply