April 13, 2011 at 12:36 pm
I have a package that calls serveral execute package tasks.....
one of these tasks is failing validation and I want to capture this information to store it in an audit table.
On the parent package I have set each of the the execute package tasks to fail the package on failure. I then have a SQL task to update a table via the OnError event handler. - This worked as I required when I tested the package and it couldn't find the package file for the execute package tasks ( I set a path using a package configuration variable).
In terms of packages failing validation my guess is that the parent package finds the child package ok, so I it doesn't generate an error in the parent. However the child package is failing during the validation phase, and doesn't seem to invoke the package OnError Event Handler (or on PostExecute, OnWarning, OnInformation for that matter)........
have I missed something here or I would have thought this should be possible ......
any clues as to what I might be missing?
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
April 13, 2011 at 1:44 pm
think I may a resolved it
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply