Re: Server Name

#1

Hello Kiran,

You can use WSH-

Set oWshNetwork = CreateObject("WScript.Network")

MsgBox oWshNetwork.ComputerName

This is demonstrated here-

Global variable diagnostic script
(http://www.sqldts.com/default.aspx?303)

Allan

Quote:

Hi All,

How can I get the server name on which the DTS package runs
dynamically. for instance, when a DTS package is success, I want to
send an email, and the email should contain the server name on which
the DTS package is running. Is there a way to get the servername
through an ActiveX Script?

Thanks
Kiran Kumar Pinjala

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

Re: Server Name

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

Re: Server Name - 01-04-2006 , 02:43 PM