Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Change ID pwd inside DTS Package

Author  Topic 

Shastryv
Posting Yak Master

145 Posts

Posted - 2006-04-26 : 11:41:59
Hi all, i have a SQL standard ID used inside couple of DTS Packages and i need to change the password for this ID once every month. Now my question is there any way that you can update the password inside the DTS Package automatically when you change the password with out having to open each and every package ?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-26 : 13:38:49
I haven't found a way to do this, which is exactly why our policy is to now use Windows Authentication for all DTS packages.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -