error handling - Report SSIS success when loop fails -
i have package has loop in it, loops through few connections. each iteration through loop new connection. problem though these connections down @ package run time. i've added on error, send email notification, , continue loop.
this works fine, using event handlers
, changing propagate
value false
. issue is, if connection fails, finish loop, report entire package fails. issue because inside job in ssms, stop job after package complete, , report failed, when did not.
is there way have package report success if loop kicks out failed e-mail? don't want "continue next step on fail" because there other parts package legit fail, , need notified on.
edit:
here screen shots of i'm doing. inside loop there dataflow
task, first dataflow
has connection fails. when does, triggers email task notify us, continue loop.
unfortunately failpackageonfailure
set false.
on task fails (or parent container if applicable), change value of failpackageonfailure
false.
if doing task in loop, may want consider whether need set failparentonfailure
false well.
edit: if none of tasks or containers causing package fail failpackageonfailure
=true, setting package fail in script. maybe in event handlers keeping count of errors, , @ end of package setting package state failure if error count <> 0.
examine all points @ setting package fail, either through script or through failpackageonfailure
property.
Comments
Post a Comment