SQL Server Performance

Scheduled job will not execute dts

Discussion in 'SQL Server DTS-Related Questions' started by mcbanx, Apr 14, 2004.

  1. mcbanx New Member

    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
  2. satya Moderator

    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.
  3. mcbanx New Member

    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
  4. satya Moderator

    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.

Share This Page