I have a DTS package that has a scheduled job. It has been running fine for over 2 years now from a scheduled job. The scheduled job will not run now. I can execute the package on its own in Enterprise Manager, but now the scheduled job creates this error

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220485 (800403FB) Error string: ActiveX Scripting : Error parsing script Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220485 (800403FB); Provider Error: 0 (0) Error string: ActiveX Scripting : Error parsing script Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed

Any suggestions, as I can't find any info on this error
Thank

Show us what is inside the Active X Script
DTSStep_DTSActiveScriptTask_1

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"kmartin" <anonymous (AT) discussions (DOT) microsoft.com> wrote

now. I can execute the package on its own in Enterprise Manager, but now
the scheduled job creates this error:
DTSStep_DTSActiveScriptTask_1, Error = -2147220485 (800403FB) Error
string: ActiveX Scripting : Error parsing script Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail Records:
Error: -2147220485 (800403FB); Provider Error: 0 (0) Error
string: ActiveX Scripting : Error parsing script Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.

I can run this same script on our testing site and it runs fine in Enterprise Manager and as a job, the scipt has not changed at all. It is a 700 line Visual Basic ActiveX Script.

OK

The error says it cannot parse the file "Error parsing script "

Do you reference external dlls or do some CREATEOBJECT() stuff?

There is something on your Production Server that the script does not like.
Running it on your Testing site is rather like comparing Apples and Pears.

Does the job owner belong to the sysadmin role?
Yes: Log onto the production server as that account | Open the package


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"kmartin" <anonymous (AT) discussions (DOT) microsoft.com> wrote

700 line Visual Basic ActiveX Script.

It is hard to tell what the issue is. But high probability is that you have security problem(because you can run DTS package and it fails as a job). Check if the job owner account still has same rights and it is not locked

Yes there are store prodcedures that are checked in the script (see below). Yes, I have checked the ownership and this is correct

Set rsData = CreateObject("ADODB.Recordset"
Set cnn = CreateObject("ADODB.Connection")