Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Retrieve Server Name?

Author  Topic 

JeffK627
Yak Posting Veteran

50 Posts

Posted - 2010-10-21 : 13:53:43
Hi All - is there a way, from a VB.NET script task in an SSIS package, to retrieve the name of the server the pakage is running on?

Thanks in advance!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-21 : 14:57:31
SELECT @@SERVERNAME

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

JeffK627
Yak Posting Veteran

50 Posts

Posted - 2010-10-21 : 15:08:47
OK, that works in a SQL task, but how do I implement that in a Script task?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-21 : 19:46:41
Not sure, you may want to ask the question on a VBScript forum.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-21 : 20:25:24
http://www.robvanderwoude.com/vbstech_network_names_computer.php
Go to Top of Page
   

- Advertisement -