SQL Server Performance Forum – Threads Archive
Problem executing DTS package on Win Server 2003Hi 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.
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. *~
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.
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>