SQL 2000 DTS pkg execution error
One of our developers, connecting to SQL through standard security, had
copied and modifed a DTS package but is unable to execute it.
The package is owned by another user. And the login account that the
developer uses to log into SQL has full DBO permission on the intended DBs.
The error msg he has received suggests that SQL Server does not exists.
Me, on the other hand, with full SA permissions, I'm able to successfully
execute this pkg.
Please advice. Thanks.