Hi,

I'm working on a group of SSIS packages at the moment and I'd like to come
up with a way to perform logging on certain events within each package. Each
package should log the same information for the same event. Rather than
duplicate this logging in each package I want to create a separate logging
package and have each of my packages call this. For example I want to log the
OnPostExecute event for each task. To do this I'm going to have the event run
my logging package but I need it to pass certain information to the logging
package, e.g. PackageStartTime, ContainerStartTime, PackageName, TaskName etc

Is there some way that I can access these variables from my child logging
package or pass them down using my parent package?

Is this the best way to do this?

Most of the variables will be system variables but there could also be some
user variables that will need to be passed down.

Thanks

Hello Neil,


Oh yes.

The parent package calls the child packages.

Declare in the Parent package variables to hold the things you want from
the children.
In the OnPostExecute event in the parent package you do whatever you want
with the local variables

In the child packages in the OnPostExecute event (Package Level) pass the
values you want to the parent variables from the child package. The child
can see the parent variables.

Remember each task's OnPostExecute is captured in the Package's equivalent
method.

The child package tasks' OnPostExecute events will be captured now in the
parent.

Help any?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com