The GetExecutionErrorInfo method issue

• NorbertA

  Say Hey Kid

  Points: 708

  More actions

  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

• trey_johnson

  Mr or Mrs. 500

  Points: 568

  More actions

  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