ActiveX Script errors suppressed

Hi

I'm trying to test some DTS packages, and ran into the familiar problem
that the package itself doesn't accurately report errors in the steps -
beyond "the step failed".
Tried running the package in the DTS Designer, tried running it by
knocking together a VB utility (using the DTS.Package2.Execute method,
with FailOnError=True, then calling GetExecutionErrorInfo for each step
in the package) - even tried running WithEvents and using the package
OnError event handler, with all the hideous problems that involves.
None of these give me any information of any use about errors - and I'm
sure I managed to get useful error information at some point in the
past (in a previous job, on some other company's server).

The result is always the same: all I get is the moronically useless
message "ActiveX Scripting encountered a Run Time error during the
execution of the script". I'm sure this didn't use to happen - I know
how to use GetExecutionErrorInfo for a reason! I used to get sensible
error messages out of ActiveX scripts in DTS packages.
Is there some basic version issue/switch/setting issue I'm missing?
I'm running SQL2K client tools talkign to a SQL2K Developer Edition
server.

thanks for any help


Seb Thirlway

.

Relevant Pages

  • Re: DTS Process Cube Task
    ... Your private dimension sounds like it's exceeding the transaction ... See if you can consistently process just that cube *by ... So you may end up with separate DTS packages to get everything ... >> place it in a different package and invoke it via a Process Task ...
    (microsoft.public.sqlserver.olap)
  • Re: Passing Global Variables, type (date) via DTSRun
    ... The package called inside this step and the package called from the similar ... >> several DTS packages that have been created by several developers. ... >> a) Use implicit conversion by setting a nvarcharvariable to the ...
    (microsoft.public.sqlserver.dts)
  • RE: VBScripts or JScripts
    ... Global variables that do not exist when first ... Prior to package execution, you can create global ... how to use ActiveX scripts in DTS ... Using Global Variables with DTS Packages ...
    (microsoft.public.sqlserver.dts)
  • RE: VBScripts or JScripts
    ... Global variables that do not exist when first ... Prior to package execution, you can create global ... how to use ActiveX scripts in DTS ... Using Global Variables with DTS Packages ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Corruption if it was generated from a script
    ... section, openned the package, used the Package Properties GUI, and added my ... I have SQL queries that use GVs in a VbScript. ... >> corrupt the DTS package. ... DTS packages created from script are ...
    (microsoft.public.sqlserver.dts)