Post reply

The GetExecutionErrorInfo method issue

  • November 8, 2004 at 4:15 am

    #60434

    Does anyone have an issue problem with the GetExecutionErrorInfo method ?
    For example I have a sample code in one Activex Script Task :
     
      Dim xoStep  
      Dim xlErrNum
      Set  xoStep =DTSGlobalVariables.Parent.Steps("DTSStep_DTSDataDrivenQueryTask_1")     

      xoStep.GetExecutionErrorInfo   xlErrNum 

     
    The GetExecutionErrorInfo method fails with error "Type mismatch".
    I can't catch the error info about a cause why other Step failure.
     
    Have any idea ?
     
    Thanks

  • November 11, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • November 11, 2004 at 12:06 pm

    #529812

    You'll need to pass the step object to a COM component as a variant as the method requires strongly typed variables.   here is the code for a method in a VB6 DLL.....

     

    Public Function GetErrorText(poStep)

    Dim lErrorCode As Long

    Dim sErrorSource As String

    Dim sErrorDescription As String

    poStep.GetExecutionErrorInfo lErrorCode, sErrorSource, sErrorDescription

    GetErrorText = lErrorCode & " | " & sErrorSource & " | " & sErrorDescription

    End Function

    Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)

    Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
    What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
    Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
    How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm

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

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