Application.GetServerVersionEx Method

아티클
12/15/2008

Returns the edition, product level, and other values that indicate the version of SSIS installed.

네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

구문

‘선언
Public Sub GetServerVersionEx ( _
    server As String, _
    <OutAttribute> ByRef editionID As Integer, _
    <OutAttribute> ByRef ssisEditionID As DTSProductLevel, _
    <OutAttribute> ByRef productVersion As String, _
    <OutAttribute> ByRef productLevel As String _
)

public void GetServerVersionEx (
    string server,
    out int editionID,
    out DTSProductLevel ssisEditionID,
    out string productVersion,
    out string productLevel
)

public:
void GetServerVersionEx (
    String^ server, 
    [OutAttribute] int% editionID, 
    [OutAttribute] DTSProductLevel% ssisEditionID, 
    [OutAttribute] String^% productVersion, 
    [OutAttribute] String^% productLevel
)

public void GetServerVersionEx (
    String server, 
    /** @attribute OutAttribute() */ /** @ref */ int editionID, 
    /** @attribute OutAttribute() */ /** @ref */ DTSProductLevel ssisEditionID, 
    /** @attribute OutAttribute() */ /** @ref */ String productVersion, 
    /** @attribute OutAttribute() */ /** @ref */ String productLevel
)

JScript는 값 유형 인수를 참조로 전달하는 것을 지원하지 않습니다.

매개 변수

server
The name of the server to get the product version information from.

editionID
An out parameter containing an integer that indicates the edition of the product. The mapping of the editionID to the edition name is shown in the Remarks section.

ssisEditionID
An out parameter containing a value from the DTSProductLevel enumeration.

productVersion
An out parameter containing the build number as seen in Help / About, formatted as major.minor.build.

productLevel
An out parameter providing the service pack level of the SSIS server.

주의

신규:2005년 12월 5일

EditionID	Edition Name
0xA485ED98	Standard Edition
0x6B9471A8	Enterprise Edition
0x81C1F4D2	Developer Edition
0x2467BCA1	Enterprise Evaluation Edition

예

The following example shows the values returned for each out parameter

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Microsoft.SqlServer.SSIS.Samples
{
    class Program
    {
        static void Main(string[] args)
        {
            String serverName = "yourServerName";
            int ed;
            DTSProductLevel prodLevel = new DTSProductLevel();
            String prodVersion;
            string prodReleaseLevel;   
            Application app = new Application();
            app.GetServerVersionEx(serverName, out ed, out prodLevel, out prodVersion, out prodReleaseLevel);

            Console.WriteLine("servernName:     {0}", serverName);
            Console.WriteLine("Edition:         {0}", ed);
            Console.WriteLine("prodLevel:       {0}", prodLevel);
            Console.WriteLine("prodVersion:     {0}", prodVersion);
            Console.WriteLine("prodReleaseLevel {0}", prodReleaseLevel);
        }
    }
}

Imports System 
Imports System.Collections.Generic 
Imports System.Text 
Imports Microsoft.SqlServer.Dts.Runtime 
Namespace Microsoft.SqlServer.SSIS.Samples 

    Class Program 

        Shared Sub Main(ByVal args As String()) 
            Dim servernName As String = "yourServerName" 
            Dim ed As Integer 
            Dim prodLevel As DTSProductLevel = New DTSProductLevel 
            Dim prodVersion As String 
            Dim prodReleaseLevel As String 
            Dim app As Application = New Application 
            app.GetServerVersionEx(servernName, ed, prodLevel, prodVersion, prodReleaseLevel) 

            Console.WriteLine("servernName: {0}", servernName) 
            Console.WriteLine("Edition: {0}", ed) 
            Console.WriteLine("prodLevel: {0}", prodLevel) 
            Console.WriteLine("prodVersion: {0}", prodVersion) 
            Console.WriteLine("prodReleaseLevel {0}", prodReleaseLevel) 
            Console.WriteLine 
        End Sub 
    End Class 
End Namespace

Sample Output:

serverName: <your server name>

Editon: 4

prodLevel: Enterprise

prodVersion: 9.00.1306.00

prodReleaseLevel: CTP16

스레드 보안

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

Application Class
Application Members
Microsoft.SqlServer.Dts.Runtime Namespace

다음을 통해 공유