DTS password problem no one seems able to fix

[Vogel]

I was debugging an existing DTS using the package designer. When I was checking the SQL server connectivity icon, I found that the user's password was blank, so I changed it.

When I pressed OK to record the change, I answered "NO" to resetting the transformations.

When I attempted to execute the package, a failure occurred with an error stating that the password was incorrect. I checked the connectivity icon. The password's change wasn't recorded. The textbox was still blank.

The package is owned and executed by me. I have full administrator rights to the domain, the server, and the database. The database uses SQL authentication. It is using SQL 7.0 (service pack 3) on a Windows NT 4.0 box (service pack 6).

I have found several other people who have experienced this problem, but no solutions.

Help!

 

[Vogel]

RESPONSE SENT BY: Darren Green

The password may not have been saved correctly. From time to time the
"Persist Security Info" property gets set to false which means the
password is not stored in the package. You can check this from within
the Advanced properties sheet of the connection.


--
Darren Green (SQL Server MVP)
DTS -

http://www.sqldts.com