posted on Monday, August 22, 2005 5:49 PM
by
Knight_Reign
Keys to looking up log entries...
A customer asked how he could programmatically determine the ExecutionID of the package so he could look up the corresponding log entries in the log tables.
Overall, this is a general problem for how to qualify searches for package metadata.
As a general rule, you can use the ExecutionInstanceGUID system variable value with the packageID as a composite primary key for accessing and maintaining package execution metadata.
Thanks,
Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden