ActiveX Scripting Error 2147220482 (800403FE) in DTS package..

From: alien2_51 (dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 11:42:14 -0700

I have a DTS package that is run from a web UI via xp_cmdshell and DTSRUN,
I'm getting an Active X script error on one of my steps only when run
through the web app, running from QA works fine...

TREAD report generation failed. DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string:
ActiveX Scripting encountered a Run Time Error during the execution of the
script. Error source: Microsoft Data Transformation Services (DTS) Package
Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0)
Error string: ActiveX Scripting ... H DEATH INJURY

I've read this article, I don't have a DefaultAcessPermissions registry
key...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q298725

Here's the script for the step thats failing... Also We've set the proxy
account for the SQL Agent job system so non-sysadmins can run this dts
package via xp_cmdshell the account has the proper permissions...

Any ideas on what could be the problem....?

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()

 Dim fso

 Set fso = CreateObject("Scripting.FileSystemObject")

 If fso.FileExists(DTSGlobalVariables("TemplateUNC").Value &
"Working\H_DEATHINJURY.XLS") Then

  fso.DeleteFile DTSGlobalVariables("TemplateUNC").Value &
"Working\H_DEATHINJURY.XLS"

 End If

 fso.CopyFile DTSGlobalVariables("TemplateUNC").Value &
"Templates\H_DEATHINJURY.XLS", DTSGlobalVariables("TemplateUNC").Value &
"Working\H_DEATHINJURY.XLS"

 Set fso = Nothing

 Main = DTSTaskExecResult_Success

End Function

Relevant Pages

  • Re: ActiveX Script errors suppressed
    ... I've never actually tried to call GetExecutionErrorInfo in an ActiveX ... >etc. ActiveX Script only has the variant type. ... >change the variant to a true string. ... Dynamic Properties task instead in the main package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Using Python in ActiveX task - works when run as separate step
    ... I just used some simple script to test: ... I installed ActivePerl on my test machine, create a new DTS package, and a ... new ActiveX script task. ... |>>>You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • Re: Running Legacy DTS on x64 2005 cluster
    ... I'm wondering if the problem is that the script task inside the dts ... "Francisco A. Gonzalez" wrote: ... Is your dts package within the SSIS execute DTS package task, ...
    (microsoft.public.sqlserver.dts)
  • Re: Revealing error info from objects instanced in script tasks
    ... >I have logging in place for ALL package events, ... >times-out when executing in an ActiveX script. ... Microsoft Data Transformation Services (DTS) Package ... >script code (such as ADO). ...
    (microsoft.public.sqlserver.dts)
  • Re: which authentication mechanism should I use?
    ... > Yes,I'd like to get a count of one table in my activeX code and then based on that count I would execute different packages .then ... > after executing each package I should Insert into a table and when the package is done I'd like to delete the record from ... >>I would ask myself why I was using ADO code inside DTS. ...
    (microsoft.public.sqlserver.dts)
Loading