Hi, I have a SSIS project with three packages :
Child2 can be executed by
Parent, but also directly in SQL Server Management Studio or DTExec.exe or SQL Command...
When I open in SSIS Catalog Reports -> Standard Reports -> All executions on
Child2), I don't see the execution started from
Parent. Same in the view
SSISDB.catalog.executions, no row for execution started from
From the documentation of the task Execute Package Task :
By default, the ExecuteOutOfProcess property of the Execute Package task is set to False, and the child package runs in the same process as the parent package. If you set this property to True, the child package runs in a separate process.
I try set
ExecuteOutOfProcess on true on task executing child package wit no success. When the child is executed by the parent, this don't add entry in the view
How execute child package from parent package and the child execution visible in the view
If isn't possible, how can retrieve execution result of child package executed from parent package (with a SQL query)?
Hi @Vernou ,
We can use the following query to get the execution of child package.
It's possible to get only statistics of the tasks 'Execute Package Task'.
Like this :
For example, I want only the highlighted rows :
(I have try
[execution_value] is not null, but this output a lot of other tasks)