Activex Scripting Encountered Runtime Error
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ActiveX Scripting encountered a Run Time Error during the execution of the script up vote 0 down vote favorite I am using an ActiveX script task in my dts package and this has worked for years. However since a week I get the following message just before the send function is called: ActiveX Scripting encountered a Run Time Error during the execution of the script. Server: SQL Server 2000 SP4 Code is: Function Main() SendEmail() Main = DTSTaskExecResult_Success End Function Function SendEmail() Dim dt dt = Date dim CurrentDate CurrentDate = Month(dt) & "/" & Day( dt ) & "/" & Year(dt) Set objMessage = CreateObject("CDO.Message") objMessage.Subject = CurrentDate objMessage.From = "xx@xx.net" objMessage.To = "xx@xx.net" objMessage.HTMLBody = CurrentDate '==This section provides the configuration information for the remote SMTP server. '==Normally you will only change the server name or IP. objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'Type of authentication, NONE, Basic (Base64 encoded), NTLM objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 'Use SSL for the connection (False or True) objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False 'Name or IP of Remote SMTP Server objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "xx.xx.net" objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "xx" 'Your password on the SMTP server objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpass
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » Data Warehousing » Data Transformation Services (DTS) » DTS ActiveX Scripting Error DTS ActiveX Scripting Error Rate Topic Display Mode Topic Options Author Message Michael ShorkeyMichael Shorkey Posted Friday, October 21, 2005 12:42 PM Grasshopper Group: General Forum Members Last Login: Wednesday, December 2, 2015 8:52 AM Points: 21, Visits: 133 This one has been driving me NUTS! I have a DTS package http://stackoverflow.com/questions/8302973/activex-scripting-encountered-a-run-time-error-during-the-execution-of-the-scrip with an ActiveX control inside that runs a VBScript that access a COM component and then inserts data into a table.What's nuts is that the DTS package runs normally when invoked via the DTS Designer, Enterprise Manager or command line prompt.If the DTS package is launched via a job (using DTSrun OS command, or xp_cmd_shell) it errors every time! The job step http://www.sqlservercentral.com/Forums/Topic231324-19-1.aspx error message is as follows:Executed as user: corp\xxxxxxxx. DTSRun: Loading... DTSRun: Executing... 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. Process Exit Code 1. The step failed.How can the package have no errors when executed manually, but error with job. Post #231324 Ninja's_RGR'usNinja's_RGR'us Posted Friday, October 21, 2005 12:57 PM SSC-Insane Group: General Forum Members Last Login: Wednesday, April 13, 2016 12:23 AM Points: 20,643, Visits: 9,671 Check the permission when run automatically... the user is most likely different causing something to be inaccessible. Post #231333 Michael ShorkeyMichael Shorkey Posted Friday, October 21, 2005 1:05 PM Grasshopper Group: General Forum Members Last Login: Wednesday,
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107334 new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | http://www.sql-server-performance.com/forum/threads/problem-executing-dts-package-on-win-server-2003.19250/ Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums Import/Export (DTS) and Replication (2000) sql 2000 dts activeX vbscript file copy failure Reply to Topic Printer Friendly Author Topic beyonder422 Posting Yak Master USA 124 Posts Posted-07/24/2008: 09:43:19 activex scripting We recently did a SAN upgrade, migrated sql server 2000 cluster to new hardware, and everything seems to be working fine except one process.A simple file copy between 2 servers.The scenario plays out that the dts package I was using before the SAN upgrade works with other servers (large and small files), but one process fails when copying to a specific server.This scheduled job works with small files (<5mb), but activex scripting encountered fails with large files (>500mb), and my testing reveals that when I try a >10mb file move the process fails with the error below.-- error message in job history -- start Executed as user: dbservice DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_4 DTSRun OnError: DTSStep_DTSActiveScriptTask_4, 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_4 DTSRun: Package execution complete. Process Exit Code 1. The step failed.-- error message in job history -- endI recently posted an error trapping question in an attempt to gather more info, but essentially the job runs for 5-10 minutes, and it looks like the copy was successful, I see the file on the remote server, but the job always reports failure...And when I try to use the file on the remote server it always comes up corrupt.Could this be a permissions issue? I think not because the sm
Problem executing DTS package on Win Server 2003 Discussion in 'SQL Server DTS-Related Questions' started by tstradli, Aug 7, 2006. 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. tstradli, Aug 7, 2006 #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. *~ waqar,