I have made changes to a DTS package at my laptop, which have accessed to the SQL 2000 server.
I am able to execute this package. But when I run this package as a scheduled job in SQL Agent, this package failed with error message “Error opening datafile. Logon invalid user or password wrong”.
I also got this error when I manually rerun this package at the server.