I set up a DTS package to run every night on my SQL 7 Server.
It is supposed to write a text file of modified rows every night.
It was working fine until I changed the password for sa, now it
fails. Also in Enterprise Manager, when I try to look a the package
properties, I get a "login failed for user sa" package error.
What to do?
