Using ActiveX script in DTS, how to post an event in windows event log

#1

We can configure DTS package to log an event in the event log if the DTS package fails or executes successfully. This works and i have tested this

In DTS, is there a way to use activex script and access EventLog

Thanks in advanc

#2

You can use the WSH Shell object to log an event from within an ActiveX
Script Task-

Set oWSH = CreateObject("WScript.Shell")
oWSH.LogEvent 0, "My Message"
Set oWSH = Nothing

WshShell Object
(http://msdn.microsoft.com/library/de...-us/script56/h
tml/wsobjwshshell.asp)

--
Darren Green
http://www.sqldts.com

"guru" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

We can configure DTS package to log an event in the event log if the DTS
package fails or executes successfully. This works and i have tested this.

In DTS, is there a way to use activex script and access EventLog?

Thanks in advance

#3

Thanks for the help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using ActiveX script in DTS, how to post an event in windows event log

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using ActiveX script in DTS, how to post an event in windows event log - 05-21-2004 , 04:01 PM

Re: Using ActiveX script in DTS, how to post an event in windows event log - 05-24-2004 , 08:37 AM

Re: Using ActiveX script in DTS, how to post an event in windows event log - 05-26-2004 , 09:46 PM