March 30, 2012 at 10:26 am
Hi all,
I hope someone else has run into this problem and has a simple fix for it.
I have a legacy DTS package running on a Windows 2008 R2 Standard (64-bit), SQL Server 2005 sp4.
It has an ActiveX control that opens an excel object and saves 4 excel tabs into 4 separate .csv files.
I can manually run the job by right-clicking the job schedule and starting the step using the sql agent service account
as well as my own domain user account. It also runs successfully when scheduled by itself as a step.
However, when scheduled to run using the sql agent service account as a step in a multi-step job, it fails and puts out an error:
"
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
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
Help file: sqldts80.hlp
Help context: 4500
Error Detail Records:
Error: -2147220482 (800403FE); Provider Error: 0 (0)
Error string: ActiveX Scripting encountered a Run Time Error during the execution of the script.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun: Package execution complete.
"
Anyone else experience this?
Thanks,
Tony
April 9, 2012 at 8:02 am
Nevermind. Found a workaround.
I created a package (A) with the ActiveX script which ran successfully by itself, then had the main package (B) run the package (A) as a task. It runs fine now.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply