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 =

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 in =
message news:ex140zC9GHA.2316@TK2MSFTNGP04.phx.gbl...
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 =