sql server dts: Question about DTS error logging -- sql server dts

You're in the

sql server dts

group:

Question about DTS error logging

jjo_chicago NO[at]SPAM yahoo.com
9/7/2004 6:53:03 AM

sql server dts: 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

Re: Question about DTS error logging

rosdav007 NO[at]SPAM hotmail.com
9/8/2004 4:31:54 AM

[quoted text, click to view]

This could help you...

Re: Question about DTS error logging

jjo_chicago NO[at]SPAM yahoo.com
9/9/2004 7:18:54 AM

[quoted text, click to view]

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."

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007

home · blog · groups

Questions? Comments? Contact the dn