Can anyone get the following VBScript to work when run in
an ActiveX Script Task in a DTS package?

Function Main()
Dim objSession
Set objSession = CreateObject("MAPI.Session")
Set objSession = Nothing
Main = DTSTaskExecResult_Success
End Function

SQL Server won't create the MAPI.Session object when the
package is executed, instead, I get an ambiguous error. I
can run the ActiveX Script step successfully if I'm in the
DTS designer and right-click over the step and
choose 'Execute Step' from the shortcut menu. I do have
CDO and Outlook installed on the SQL box and am able to
use full blown VB to create and manipulate a MAPI.Session
object on the box.

Any help is greatly appreciated.
Thanks,
Jeff

Works for me.
One thought is to make sure the task is set to execute on
main thread - I've seen problems before when this isn't set.

-Sue

On Thu, 22 Jul 2004 10:08:50 -0700, "Jeff M"
<anonymous (AT) discussions (DOT) microsoft.com> wrote: