Groups | Blog | Home
all groups > sql server dts > june 2005 >

sql server dts : error: ActiveX Scripting encountered a Run Time error...


OutlookNewbieDev
6/7/2005 3:33:17 PM
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


OutlookNewbieDev
6/8/2005 10:29:02 AM
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


[quoted text, click to view]
JFB
6/8/2005 12:07:34 PM
Try to set the package to run on main thread. This option is in pkg
properties.
Rgds
JFB

"OutlookNewbieDev" <OutlookNewbieDev@discussions.microsoft.com> wrote in
message news:8230C89C-25E0-4BA1-880D-90211C2BE047@microsoft.com...
[quoted text, click to view]

OutlookNewbieDev
6/8/2005 2:41:01 PM
That worked. Thank you.

OND

[quoted text, click to view]
JFB
6/8/2005 3:59:37 PM
Ok, on the task.. right mouse click
Workflow Properties-->Options-->check Execute pkg on main thread
Rgds
JFB


"OutlookNewbieDev" <OutlookNewbieDev@discussions.microsoft.com> wrote in
message news:52DE3FF9-8F9F-4051-90D1-391976B17DF5@microsoft.com...
[quoted text, click to view]

AddThis Social Bookmark Button