Very Computer

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!

Quote:>Hi,

>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!

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

THANK YOU! It worked. I have already posted the solution to the other
people.

THANKS!

Vince

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!