I have SA permission on that SQL 2000 server. I can access that SQL server by
using Enterprise Manager from my PC. If I open a DTS package saved in "local
packages" on that server, I can open any DataPump connections.
But when I open a DTS package saved as .dts file on that server, I can not
open any DataPump connections. Double click DataPump connection bar, I get
error: "SQL Server does not exist or access denied".
I have SA permission no that server. I also have full control permission on
the local disks of that server.
Why this issue?

Thanks in advance,

Hello Mike,

are the packages you are trying to open simply SSF copies of the ones stored
in SQL Server or are they different?

Disk permissions are unlikely to be the issue.

open up the connection in the DP task and make sure it is pointing where
you think it is.


Allan

Thanks Allan. You get it.
I find out it points to wrong location.



"Allan Mitchell" wrote: