sql server dts: deploy fails -- sql server dts

deploy fails

shank
8/31/2007 4:32:21 PM

sql server dts: If there's an SQL 2005 admin around, I'd appreciate an interpretation on the
below error. I'm trying to deploy an SSIS package to a shared SQL 2005 host.
They claim they allow installations of such packages, but it appears to me
they do not have permissions setup correctly.

- - - - - - - - - - - - - - - - - - - -
Additional information
- The SavetoSQLServer method has encountered OLE DB error code 0x80040E09
(The EXECUTE permission was denied on the object sp_dts_putpackage...
- - - - - - - - - - - - - - - - - - - -

Can someone advise instructions on what I can tell them to change on their
end?

thanks

Re: deploy fails

jhofmeyr NO[at]SPAM googlemail.com
9/3/2007 2:31:28 AM

[quoted text, click to view]

Hi Shank,

This definitely looks like a permissions issue.

Check out http://msdn2.microsoft.com/en-us/library/ms141053.aspx for
more info on what permissions need to be granted. It might be worth
checking seperately whether the user you are connecting with has read
and write permissions on the sysdtspackages90 table in MSDB. Finally
- you might also need to check out http://msdn2.microsoft.com/en-us/library/aa337083.aspx

Good Luck
J