SQL Server Performance

Problem executing DTS package on Win Server 2003

Discussion in 'SQL Server DTS-Related Questions' started by tstradli, Aug 7, 2006.

  1. tstradli New Member

    Hi

    I have a SQL Server 2000 DTS package that instantiates a JAVA object and completes a HTTP post. This package works fine when I run on Windows XP however now I have moved from my development environment to test on a Windows 2003 environment I am getting the following error.

    DTSRun: Loading...

    DTSRun: Executing...

    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1

    DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1

    DTSRun OnStart: DTSStep_DTSActiveScriptTask_1

    DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)

    Error string: ActiveX Scripting encountered a Run Time Error during the execution of the script.

    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: ActiveX Scripting encountered a Run Time Error during the execution of the script.

    Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts80.hlp

    Help context: 4500



    DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1

    DTSRun: Package execution complete.

    NULL


    I have read herehttp://support.microsoft.com/default.aspx?scid=kb;EN-US;q298725 that this is likely a permission problem with creating the JAVA object either because my COM security permissions are not correct or DTS is not in the registry. However I have verified my COM security is correct and run the DTS dlls into the registry and I am still getting this error. Also note that the version of JRE on the machine that is not working on is later than that on the machine where it is working.

    Does anyone know another reason for this error on Win Server 2003? How do I use the Help file: sqldts80.hlp
    and associated Help context: 4500 message to research my issue?

    Many thanks

    T.
  2. waqar Member

    Tstradli,

    I will suggest to narrow down your activex issue by only executing command which is calling your activex object. Most of the times this problem occur when SQL have problem with activex object.

    If it don't work, may be you wanted to paste some of your code so that someone can have a look to assist you.

    Waqar.

    ________________________________________________
    ~* Opinions are like a$$holes, everyone got one. *~
  3. tstradli New Member

    Thanks.

    The issue was that the new machine does not have the Microsoft JVM on it (though it did have another JVM) and DTS seems to use this as a default.

    Is it possible to get an Active X script in DTS to use a version of JVM other than the Microsoft JVM?

    I understand that the Microsoft JVM will be desupported end of 2007.
  4. FrankKalis Moderator

    Moved to a more appropriate forum. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

Share This Page