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.

variables

however, duplicate warning messages still being thrown in order of:

  1. script
  2. foreach loop container
  3. 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

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -