Logging DTS Error message to table?

  • Hello,

    I am trying to implement error handling into one of my packages.  I would like to log all errors to a single sql server table.  So I would not have to sift through the error logging text file.   I am using an active x script and getting step name, step start time, step end time by setting variables = oStep.Name, oStep.StartTime, oStep.Endtime.   But the value I cannot figure out how to get is the actual error message itself to log to my table.  Does anyone know how to do this?

    Any help would be greatly appreciated.

     

    Thank You.

    Erin Glenn

  • Just use the Err object.

    Err.Number

    Err.Description

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply