sql server dts: I have a DTS package that has a scheduled job. It has been running fine for over 2 years now. I can execute the package on its own, 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.

Has it been running as a scheduled job for over 2 years or on its own? The
error leads me to believe there is a problem with the script itself. Can
you manually execute the package from Enteprise Manager running on the SQL
Server itself (not from a client)? If this also fails then try running the
script using the Windows Scripting Host and see if the error reprodcues. If
so then you should make sure the vbscript.dll version on the SQL Server and
on a client where you can execute the package manually are the same.

Hope this helps,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.