Scheduled job will not execute dts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Scheduled job will not execute dts

Hi, I have a DTS package that uses vb script to call a dll which reads some custom file properties, populates a table, then sends an email. It runs fine if I execute the DTS manually but when I schedule it as a job and run it I receive the following error; Executed as user: CMICROsqladmin. …DTSRun: Executing… DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= TextParse Error Description: Class does not support Automation or does not support expected interface Error on Line 63 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: Error Code: 0 Error Source= TextParse Error Description: Class does not support Automation or does not support expected interface Error on Line 63 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed. Any ideas? Thanks,
Mike Banks
Can you actually check the versions on the machines involved? Check your project references, and ensure that the same components (and versions) or all referenced objects are installed and registered on the server. Also ensure similar version of MDAC and service pack levels installed.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks, I went ahead and created a vb setup package to deploy the dll. I copied the vb package to the server and ran it and now the job will execute the DTS package. Mike Banks
Thats what I was intended to say, the reason it failed due to mismatch or missing .DLL file created by the application. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>