Question about DTS error logging

From: Joe (jjo_chicago_at_yahoo.com)
Date: 09/07/04 

Date: 7 Sep 2004 06:53:03 -0700

Hello!

Anyone know how to access the error descriptions via VB script (not full
VB, I am using the DTS gui to design & execute)?

I am logging the insert or transform errors in SqlServer, but cannot
figure out how to access the specific error message (the one that comes up in
the text log file) like "..insert of x column failed because of NULL .. ".
 
The closest was an Error Code from the DTSTransformPhaseInfo object, but I have
no idea what error description this correlates to or even if it is the same
error. I am sure this can be accessed from *somewhere*, since after all, it is
being written to the exception file.

Any help will be much appreciated! I've spent hours searching, and have come
up with nothing.

Relevant Pages

  • Re: Write log file using Thread
    ... It sounds like you are talking about having an asynchronous process for logging stuff so that you can return control to the user instead of blocking the UI thread. ... Actually my programm execute a function and at the end of the function ... i write the duration time to a log file. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Logging components?
    ... I think Logging is pretty much individual, so that usualy everyone has their ... {Write Logged exception into the Log file? ... {Write exception with a short string description into the Global App Log ... > By logging components, I specifically DON'T MEAN components for catching ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: TDD doesnt suck
    ... That is a system that I often call a "Test-Like Thing". ... that come to mind are A> lots of assert statements, ... works for a narrow range of problems - the ones that can emit a log file. ... have reinvented is it doesn't design your code for testage. ...
    (comp.programming)
  • Re: Remove GP from machine that has been removed from AD
    ... Location of the log file - %windir%\security\logs ... Execute a gpupdate /force, verify you get the 1202 event, and post the log ... CCNA, MCSE 2000/2003 + Security ... My machine took the normal> Group Policy. ...
    (microsoft.public.windows.group_policy)
  • Re: Phantom /var full messages
    ... if you could isolate it to just snort or just MySQL. ... without restarting the program that's logging to them. ... compresses the current log file into a new file, ...
    (freebsd-questions)
Loading