SQL Server Performance

Server Name

Discussion in 'SQL Server DTS-Related Questions' started by nareshb, Jun 27, 2007.

  1. nareshb New Member

    Hi,

    I want to retrieve server name(on which package is present) in activeX script of that DTS package. However I don't want to run a sql command on an ADO connection. Any suggestion using only ActiveX script is required. Thanks in advance....

    On the same notes how to retrive the package name?
  2. satya Moderator

    What is the problem in running @@SErvername?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. nareshb New Member

    I want the same package on two servers, test and production, I want to delete some data on a third server, if production server package is running. I dont same package to run on both the servers but do different functionality based on servername condition.

    if ( server_name = Production)
    do something;
    if (server_name = test)
    do something else;

    Is there some OLE DB provider property from which we can retrieve the server name?
  4. ranjitjain New Member

    You can access the connection object which you have created in your package
    through activeX script.

    In your script add this:
    Dim oConnection As ConnectionManager
    oConnection = Dts.Connections("Connection Name")
    Dim sServer As String = CStr(oConnection.Properties("ServerName").GetValue(oConnection))

Share This Page