Updating Username and Password of DTS Packages

• Stags

  SSC Enthusiast

  Points: 190

  More actions

  March 2, 2010 at 4:02 am

  #100112

  Hi All

  I have a number of DTS packages executing with the sa login. We are trying to change the sa password, to comply with the companies security police. Is there a way for me to update the password on the DTS packages in bulk? Is there a system table that can be updated?

  Any assistance would be greatly appreciated...

  Thanx.

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  March 2, 2010 at 4:31 am

  #1126953

  check the following link

  http://bytes.com/topic/sql-server/answers/78672-dts-package-owner

• Stags

  SSC Enthusiast

  Points: 190

  More actions

  March 2, 2010 at 4:57 am

  #1126969

  Thanx Vyas...

  I think that this will do the "trick"

  Appreciate your help.