 | |
error: ActiveX Scripting encountered a Run Time error...
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
error: ActiveX Scripting encountered a Run Time error... -
06-07-2005
, 05:33 PM
#2
| |||
| |||
|
|
Hi All, I have created a DTS package with an ActiveX Script calling the CDO/MAPI object: dim oMapi Set oMapi = GetObject("", "MAPI.Session") and I get this error: ActiveX Scripting encountered a Run Time error during the execution of the script. I have everything setup correctly as far as CDO/MAPI working. I have the same code in a VBScript (.vbs) file, and it executes fine at the command line. Does anyone know what is causing this? Thanks, OND |
#3
| |||
| |||
|
|
Try to set the package to run on main thread. This option is in pkg properties. Rgds JFB "OutlookNewbieDev" <OutlookNewbieDev (AT) discussions (DOT) microsoft.com> wrote in message news:8230C89C-25E0-4BA1-880D-90211C2BE047 (AT) microsoft (DOT) com... Hi All, I have created a DTS package with an ActiveX Script calling the CDO/MAPI object: dim oMapi Set oMapi = GetObject("", "MAPI.Session") and I get this error: ActiveX Scripting encountered a Run Time error during the execution of the script. I have everything setup correctly as far as CDO/MAPI working. I have the same code in a VBScript (.vbs) file, and it executes fine at the command line. Does anyone know what is causing this? Thanks, OND |
#4
| |||
| |||
|
|
I don't see it in the properties window. I see tabs for "General", "Global Variables", "Logging", and "Advanced" and looked at all of them but don't see a setting for it. I'm running SQL Server 2000... Regards, OND "JFB" wrote: Try to set the package to run on main thread. This option is in pkg properties. Rgds JFB "OutlookNewbieDev" <OutlookNewbieDev (AT) discussions (DOT) microsoft.com> wrote in message news:8230C89C-25E0-4BA1-880D-90211C2BE047 (AT) microsoft (DOT) com... Hi All, I have created a DTS package with an ActiveX Script calling the CDO/MAPI object: dim oMapi Set oMapi = GetObject("", "MAPI.Session") and I get this error: ActiveX Scripting encountered a Run Time error during the execution of the script. I have everything setup correctly as far as CDO/MAPI working. I have the same code in a VBScript (.vbs) file, and it executes fine at the command line. Does anyone know what is causing this? Thanks, OND |
#5
| |||
| |||
|
|
Ok, on the task.. right mouse click Workflow Properties-->Options-->check Execute pkg on main thread Rgds JFB "OutlookNewbieDev" <OutlookNewbieDev (AT) discussions (DOT) microsoft.com> wrote in message news:52DE3FF9-8F9F-4051-90D1-391976B17DF5 (AT) microsoft (DOT) com... I don't see it in the properties window. I see tabs for "General", "Global Variables", "Logging", and "Advanced" and looked at all of them but don't see a setting for it. I'm running SQL Server 2000... Regards, OND "JFB" wrote: Try to set the package to run on main thread. This option is in pkg properties. Rgds JFB "OutlookNewbieDev" <OutlookNewbieDev (AT) discussions (DOT) microsoft.com> wrote in message news:8230C89C-25E0-4BA1-880D-90211C2BE047 (AT) microsoft (DOT) com... Hi All, I have created a DTS package with an ActiveX Script calling the CDO/MAPI object: dim oMapi Set oMapi = GetObject("", "MAPI.Session") and I get this error: ActiveX Scripting encountered a Run Time error during the execution of the script. I have everything setup correctly as far as CDO/MAPI working. I have the same code in a VBScript (.vbs) file, and it executes fine at the command line. Does anyone know what is causing this? Thanks, OND |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.