I've set up the framework exactly how you have described it in the book (Awesome by the way!), but when i look at the log for a single variable i have set to raise change event, it's logged multiple times within milliseconds of each other (no actual change to the value). I do have the variable i'm logging within a parent package.

Is that inherent in the logging procedure or the way i have the package within a parent?

Hi brendenm,

Are the records showing up with any differences? The way events bubble up in the package, it may be logging at each level.

Something to try would be to include a script task before the Variable that filters the event if it is at anything other than the Package level. Please let us know if that works for you!

Best,
Jessica

I'm not sure if this will show right but below is a sample of what I'm seeing:

Within milliseconds a second error on the same task with the same error code and description is logged, but with different ErrorLogID and PackageLogID.


PackageErrorLogID PackageLogID ErrorCode LogDateTime
4 4 -1073548540 2010-06-22 13:04:02.860
5 3 -1073548540 2010-06-22 13:04:02.897

I guess it logs one for the parent package and one for the child since i have the error handling on both parent and child?

Sorry i meant to include the output from the variable log table: Here it is:

PackageVariableLogID
3
4
PackageLogID
4
3

VariableName
File_Name
File_Name

VariableValue
JPM_6162010.zip
JPM_6162010.zip

LogDateTime
2010-06-22 13:04:02.643
2010-06-22 13:04:02.660

Same deal. Two logs within milliseconds. No change in variable.
Do i need to have the parent package set to not log that change event? How do i modify to log only once per variable change?

Hi brendenm,

Yes, the events are bubbling up to the parent package. Your best bet will be to set the DisableEventHandlers property on the Execute Package Task in your parent package to false.

Best of luck!
Jessica

Thanks Jessica! Just to clarify, the disableEventHandlers on a Execute Package Task within a Parent package will not negate the handlers within the child package itself, only an event being logged from the Parent package related to that specific Task?

This same scenario works for tasks within containers, correct? If you disable the event handlers on the container but not the tasks you'll still get an entry in the error log but only once per task instead of twice, correct?

Thanks again!
Brenden

Definitely - the child package executes in its own little world and cannot be modified by the parent package, unless you specifically force it through a configuration.

-Jessica