Activex Scripting Encountered A Runtime Error

(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)  HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: ActiveX Scripting encountered a Run Time Error during the execution of the script. SQL Server > SQL Server Integration Services Question 0 Sign in to vote It just stopped running with no changes to the server. Any help will be welcomed. Message Executed as user: IGSLAN\svc-finsql. 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. A DTS package TYPE = ActiveX Script Task: undefined Package 'Simple Mail Transfer Protocol (SMTP) Server Name Const SMTP_SERVER = "smtp.intergraph.com" Dim TheMsg TheMsg="The attached orders and/or contracts have been received by IGS Contracts and have been reviewed to confirm that, in accordance with procedures, " TheMsg=TheMsg & "persuasive evidence of a contractual arrangement exists between Intergraph Government Solutions and the customer. Copies of orders will be saved " TheMsg=TheMsg & "to \\coral\IGSC-BusOps\COTS. Contracts are named by COTS ID log number. " TheMsg=TheMsg & "

This e-ma

up 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 with an ActiveX control inside that https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5f3e70c8-dc86-414d-9496-fe4c855b9454/activex-scripting-encountered-a-run-time-error-during-the-execution-of-the-script?forum=sqlintegrationservices 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 error message is as follows:Executed as user: corp\xxxxxxxx. DTSRun: http://www.sqlservercentral.com/Forums/Topic231324-19-1.aspx 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, December 2, 2015 8:52 AM Points: 21, Visits: 133 That has been checked already. The connection to the database is using

SQL Server experts to answer whatever question you can come up with. Our new http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107334 SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.dts/2006-11/msg00037.html 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) activex scripting 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 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 activex scripting encountered 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 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

sometimes, but it only fails when it tries to copy a large(about > 90mb) text file contents from source to destination file. For file size less then 50 mb it has always worked perfectly fine, but sometimes we have files greater then 100 mb and that's we the below code fails. Is there any limit on .write method on FilesystemObject or am i missing something very obvious here. CODE with DTS package ActiveXScript sSourceFile = "a.csv" sDestinationFile = "b.csv" Set oCFSO = CreateObject("Scripting.FileSystemObject") Set oCFile = oCFSO.OpenTextFile(sSourceFile, 1,,-2) strContents = oCFile.ReadAll oCFile.close Set oCFile = oCFSO.OpenTextFile(sDestinationFile, 2,True,0) oCFile.Write(strContents) oCFile.close ' Clean Up Set oCFile = Nothing Set oCFSO = Nothing Error message i get is as follows Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:ActiveX Scripting encountered a Run Time Error during the execution of the script. Step Error code: 800403FE Step Error Help File:sqldts80.hlp Step Error Help Context ID:4500 Can anybody please help me on above problem, as i need to fix it very urgently. Regards Nirav Lulla . Prev by Date: Distributed Transaction Next by Date: Failed OLE DB Source parameter mapping in data flow component Previous by thread: Distributed Transaction Next by thread: Failed OLE DB Source parameter mapping in data flow component Index(es): Date Thread Flag as inappropriate (AWS) Windows Science Usenet ArchiveAboutPrivacyImprint www.tech-archive.net >Archive >SQL-Server >microsoft.public.sqlserver.dts >2006-11