GetExecutionErrorInfo fails...help

#1

Hello,

I know that GetExecutionErrorInfo doesn't work when called from within
a VB script. So I downloaded the zip file that the ActiveXHelper COM object
from
http://www.sqldts.com/redir.aspx?45, and registered the ActiveXHelper DLL as
a
COM object, but still can't get the function to work within a script. Can
you maybe tell me what I'm doing wrong? Here's a code
snippet:

dim objStepError
Set objStepError = CreateObject("DTSActiveXHelper.HelperClass")

#2

Finally got round to it, see your original post...

Darren

In message <9C2AEDE3-6A9D-46F2-9E42-975269622AFD (AT) microsoft (DOT) com>, Tom P
<TomP (AT) discussions (DOT) microsoft.com> writes

Quote:

Hello,

I know that GetExecutionErrorInfo doesn't work when called from within
a VB script. So I downloaded the zip file that the ActiveXHelper COM object
from
http://www.sqldts.com/redir.aspx?45, and registered the ActiveXHelper DLL as
a
COM object, but still can't get the function to work within a script. Can
you maybe tell me what I'm doing wrong? Here's a code
snippet:

dim objStepError
Set objStepError = CreateObject("DTSActiveXHelper.HelperClass")
.
.
.
For Each oStep in oPkg.Steps
If oStep.ExecutionStatus = DTSStepExecStat_Completed Then
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
objStepError.GetExecutionErrorInfo oStep,lErr, sSource,
sDesc,NULL,NULL,NULL
MsgBox lErr
End If
End If
Next

BTW, I registered the object by just running regsvr32 from a command line.

Thanks,
Tom

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

GetExecutionErrorInfo fails...help

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

GetExecutionErrorInfo fails...help - 05-18-2005 , 02:53 PM

Re: GetExecutionErrorInfo fails...help - 05-18-2005 , 03:17 PM