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.

loop

properties

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

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

unity3d - Fatal error- Monodevelop-Unity failed to start -