The Dts.Log method seems to be working in main package script task. However it does not seem to work within the script task within an event (executes without error). The...

I am not sure if the procedure or script is really needed for this. May be you should try following

Go to Options and Query results one of the option has...