 Re: EXECUTE permission denied on object 'sp_dts_getpackage', database 'msdb', schema 'dbo'. -
10-20-2006
, 07:27 AM
Ok, fixed it myself, but just in case anybody else has the problem here is the solution ...
The SQL User that is specified in the connection object settings must have db_dtsoperator writes to the msdb database. Once this is granted, Visual Studio (Business Intelligence Studio) is able to iterate the packages installed on the server and allow you to choose one. This same permission also allows the initial package to call the second package.
Martin.
"Martin Robins" <martin at orpheus-solutions dot co dot uk> wrote
I am in the process of finalising some new SSIS packages (based upon previous DTS packages, but re-created in SSIS from scratch). One of the packages that I am recreating needs to call another of the packages when it has completed, however whenever I try this, I get an error. Further more, when I add an "Execute Package Task" I cannot browse packages using the elipses next to the "PackageName" property - this gives me a really useful error message ...
TITLE: Execute Package Task
------------------------------
No description found
------------------------------
ADDITIONAL INFORMATION:
No description found
------------------------------
BUTTONS:
OK
------------------------------
I have tried entering the package name manually, but if I then try and run the task, it generates the error message above (in the title).
The SSIS packages have been installed to the server on which the job is running using the "Package Installation Wizard" and are visible through the SSMS.
I am using SQL Server Security for the user that the package is being run under, and that user has "public" access to the msdb database.
Does anybody have any suggestions as to what could be the cause of the problem?
 |
Linear Mode
