Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shank
Starting Member
6 Posts |
 Posted - 2007-08-31 : 17:03:44
|
| 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? .. or my end?thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-31 : 17:52:57
|
| The problem is on their end. Just have them look at the exact error message. It says right there that you don't have permissions to save the package in the server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
deply fails