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.

jjo_chicago (AT) yahoo (DOT) com (Joe) wrote in message news:<13861d6d.0409070553.7de045a9 (AT) posting (DOT) google.com>...


This could help you...

http://msdn.microsoft.com/library/de...ethai_98v8.asp

That does not help. The GetExecutionErrorInfo Method cannot be
invoked from VB Script. Quoting:

"GetExecutionErrorInfo uses ByRef parameters to pass back the
information
such as error description etc. These are type variables, long and
string
etc. ActiveX Script only has the variant type. For ByRef to work the
types must match exactly. Using CStr and similar only suppresses the
error by ensuring the data passed in is type correctly, but does not
change the variant to a true string. You will need to use a strongly
type language. You could write a DLL in VB that could be called from
ActiveX Script o even write a custom taks to do the entire error
capture
job. Using a custom task gives reuse too, without copy and paste of
code
between packages."



Source: http://www.google.com/groups?hl=en&l...r%3D%26hl%3Den