sql server - SSIS prevent warnings from propagating -
i've got script running in foreach loop container, inside package's control flow.
in script, throwing warning, exiting success
dts.events.firewarning(-1, "", "warning message here", "", 0); dts.taskresult = (int)scriptresults.success;
i've set system propagate variables false.
also tried setting package property disableeventhandlers true.
however, duplicate warning messages still being thrown in order of:
- script
- foreach loop container
- package
i possibly log each incident information instead of warning... dont want log information. logging warnings more realistic.
create onwarning event handler script task. event handler not need tasks of own, need system variable propagate set false.
Comments
Post a Comment