Hi,
I am trying to schedule a DTS package which imports data from a remote
server to a local server.
I have left Owner password & User password blank.I have verified that I
have access to the remote server. It is throwing the following error :
EXECUTE permission denied on sp_add_dtspackage, database 'msdb', owner
'dbo'
If anyone knows about this error, please let me know.
Thanks in advance,
Ashish.

I figured out the problem. I was trying to save the package in the
remote server where I did not have access on msdb database.I changed
the destination to save in the local server. Now it is working fine.
-Ashish.


ashtek (AT) gmail (DOT) com wrote: