CODEWITHSUNDEEP
sql-serverssisssis-2012
Dave Ward
Dave Ward

Reputation: 107

SSISDB false success report

I am running a set of SSIS packages via SSISDB which are returning a overall success message even though child packages controlled by the parent package fail.

The packages consist of a parent package which calls child packages in sequence.

Is there a way to set the SSISDB report to show an overall status of failure if a child packages fail?

Upvotes: 2

Views: 81

Answers (1)

Jayvee
Jayvee

Reputation: 10875

You may need to set FailParentOnFailure to True, on the Execute Package Task properties of the task that runs the child package.

Upvotes: 3

Related Questions