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

java - How to Configure JAXRS and Spring With Annotations -

visual studio - TFS will not accept changes I've made to a Java project -

php - Create image in codeigniter on the fly -