sql server dts: Error:EXECUTE permission denied on sp_add_dtspackage, database 'msdb', owner 'dbo' -- sql server dts

Error:EXECUTE permission denied on sp_add_dtspackage, database 'msdb', owner 'dbo'

ashtek NO[at]SPAM gmail.com
10/4/2006 10:11:09 PM

sql server dts:

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.

Re: Error:EXECUTE permission denied on sp_add_dtspackage, database 'msdb', owner 'dbo'

ashtek NO[at]SPAM gmail.com
10/5/2006 1:36:45 AM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.