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

Subject: Re: scheduled job failure 1/9/2004 12:28 PM PST

By: Allan Mitchell (search by author) In: microsoft.public.sqlserver.dts

Show us what is inside the Active X Scrip
DTSStep_DTSActiveScriptTask_

By: kmartin (search by author) In: microsoft.public.sqlserver.dts

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.

By: Diana (search by author) In: microsoft.public.sqlserver.dts

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 locke

By: Allan Mitchell (search by author) In: microsoft.public.sqlserver.dts

O

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 packag
By: kmartin (search by author) In: microsoft.public.sqlserver.dts

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"

Any more info, please?

If you are inputting a delimited text file to the script it is possible that
the text file has delimiters IN the fields... One way to test for this is to
open the DTS package, open the source file and go through the motions of
setting up the parsing of the exact same input file... If the parsing of the
input file is the problem, you'll get an error in design mode...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
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.
700 line Visual Basic ActiveX Script.
job). Check if the job owner account still has same rights and it is not
locked